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: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
