Forms and MySql date
| From: | Mike Tuller | Date: | Thu, 20 Feb 2003 22:43:10 +0000 |
| Subject: | Forms and MySql date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-136425@lists.php.net to get a copy of this message | ||
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