RE: [PHP-DB] Date format

Not sure about MS Access, but I had the same problem with MySQL. I could not get the date converted with the PHP functions. I ended up reformatting the data in my SELECT statement... "SELECT DATE_FORMAT(date, '%M %D, %Y'),text FROM news order by date desc" I'm not sure if Access is capable of reformatting the output in this manner. Hope it helps a little. Mario -----Original Message----- From: Vojtech Dvorak [mailto:vojtech_dvorak@servind.cz] Sent: Monday, July 17, 2000 9:50 AM To: php-db@lists.php.net Subject: [PHP-DB] Date format I am using ODBC to get a dates from my MS Access database, but problem comes when I need change format of dates I get.. What I get is: "2000-04-12 14:06:09" what I need is only: "12-04-2000" Do someone know how should I make it? Thanks Vojtech -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net