mysql stores date as yyyy-mm-dd that is how the date should be entered into the form
If entered in another format, you can reformat it. ----- Original Message ----- From: "Mike Tuller" <[EMAIL PROTECTED]> To: "php mailing list list" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 4:43 PM Subject: [PHP] Forms and MySql date I have a form that I want to enter a date into a MySql database. I currently have the column in the database set as Date, and can't seem to get the date I enter into the text field to go into the database using the format yymmdd. I could change the column to varchar, and then it would enter, but this will be a database that I want to keep track of purchases, and if it is entered in as text, I wouldn't be able to do calculations such as showing how old something is. How can I have a text field where a person enters the date and have that information entered into the database? Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php