extracting/formatting date with ODBC
Posted: Sun Dec 07, 2003 9:49 pm
I am trying to extract a date from my Access database:
the date is formatted mm/dd/yyyy. ie 12/07/2003
However when I loop through all the dates it displays it as:
2003-12-07 00:00:00.
How do I format it so that it displays like 12/07/2003 or 12-07-2003.
Thanks
Code: Select all
$wo_dates = "SELECT date FROM workout_t";However when I loop through all the dates it displays it as:
2003-12-07 00:00:00.
How do I format it so that it displays like 12/07/2003 or 12-07-2003.
Thanks