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.


-----Original Message-----
From: Paul Ihrig [mailto:pihrig@;]
Sent: Tuesday, November 12, 2002 6:27 AM
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 (
To unsubscribe, visit:

Reply via email to