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.
