Re: date questions in mySql

check out the date( ) function in mysql. a quick prelude of it is.....select date(date_col, %m/%d/%Y) from table...this will take yyyy-mm-dd and return mm/dd/yyyy "Paul Ihrig" <pihrig@columb To: <php-db@lists.php.net> us.rr.com> cc: Subject: [PHP-DB] date questions in mySql 11/12/2002 09:26 AM ok i can parse a date from mySql date field so it displays as: 08/06/1972 but if i insert it into the field in this format then the date gets hosed. do i have to insert as yyyy-mm-dd can i have a form field that has mm/dd/yyyy but then change it on insert? how would i do this? thanks. -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php