Re: Date format

No, you can't use this with ODBC... Thanks anyway Vojtech ----- Original Message ----- From: Cosenza, Mario <mcosenza@engsvcs.com> To: 'Vojtech Dvorak' <vojtech_dvorak@servind.cz>; <php-db@lists.php.net> Sent: Monday, July 17, 2000 3:47 PM Subject: 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 > > -- > 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 > > >