I'm using Mysql 4.0.15, MyODBC 3.51.06 and ADO 2.8. My problem is that when I retrieve data from a table with a datetime column "SELECT master.Fulldate ..." (Fulldate is the datetime column), I normally get a recordset whose first column is of adDBTimeStamp type (ado 135). As soon as I need aggregate functions as "SELECT SUBSTRING(master.Fulldate,1,13) as Fulldate ... GROUP BY Fulldate" to get hourly averages, the recordset field type change to adChar (129) and is no longer treated as a valid date. Is there a way to still get a date column's field type ?
I tried both CAST() and CONVERT() functions with no success, the field type is still adChar instead of datetime. I then installed MyODBC 3.51.08 and this time the field type was adBinary (ado 128)! I tried with MySql server 4.0.20d with the same result. I'm gonna try on another machine to see what's going on