Hello i run a mysql query with vb6,
values returned are all ok except thoose two :

concat( substring( datetimefield, 15, 2 ) , substring( datetimefield, 12, 2 ) ) AS 'Minuteandhour'

concat( substring( datetimefield, 9, 2 ) , substring( datetimefield, 6, 2 ) , substring( datetimefield, 3, 2 ) ) AS 'DDMMYY'

datetimefield is date time type (YYYY-MM-dd hh:mm:ss)

For thoose two fields it returnes "??????????" .
Any ideas?
Thank you.