RE: date questions in mySql
| From: | Jonathan Narong | Date: | Tue, 12 Nov 2002 23:21:34 +0000 |
| Subject: | RE: date questions in mySql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23274@lists.php.net to get a copy of this message | ||
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.
-jon
-----Original Message-----
From: Paul Ihrig [mailto:pihrig@columbus.rr.com]
Sent: Tuesday, November 12, 2002 6:27 AM
To: php-db@lists.php.net
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?
thanks.
-paul