Unanswered: Dates displaying as 10/29/2003 instead of 29/10/2003
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?