You could use the TO_DATE function to convert that text string into a date, or reformat it in PHP to yyyy-mm-dd which mysql will take automatically (at least I think so)
On Thu, 20 Feb 2003, Mike Tuller wrote: > 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
