Page 1 of 1

extracting/formatting date with ODBC

Posted: Sun Dec 07, 2003 9:49 pm
by ericsodt
I am trying to extract a date from my Access database:

Code: Select all

$wo_dates = "SELECT date FROM workout_t";
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

Posted: Mon Dec 08, 2003 12:20 am
by m3mn0n
Matter being discussed elsewhere.

viewtopic.php?t=15398