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