I have a table in mysql which has a column of datetime

when i run a query in mysql control panel and the dates are returned they are returned as 2002-04-22 00:00:00 yet if i run a an ASP page using myodbc to connect to the server and i print the same column out on the web page it comes out as 4/22/2002.

I have no formtting on the date field just as its returned from the ado recordset.

Anyone had the same problem and know how to fix it?


Cheers.

That is MySQL's default dete format.

You need to look at the function DATE_FORMAT()

Regards,
Matt.