Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    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?


    Cheers.

  2. #2
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    That is MySQL's default dete format.

    You need to look at the function DATE_FORMAT()

    Regards,
    Matt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •