yes, you need to insert the date as yyyy-mm-dd. you can go around this and
still have the user see a form field with mm/dd/yyyy but you need to break
each part down, and play with the string functions so the final mysql query
is in yyyy-mm-dd.
From: Paul Ihrig [mailto:pihrig@;columbus.rr.com]
Sent: Tuesday, November 12, 2002 6:27 AM
To: [EMAIL PROTECTED]
Subject: date questions in mySql
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?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php