Re: date format for MySQL
| From: | Mark Maggelet | Date: | Wed, 21 Feb 2001 19:50:28 +0000 |
| Subject: | Re: date format for MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-41044@lists.php.net to get a copy of this message | ||
On Wed, 21 Feb 2001 11:36:02 -0800, Jerry Lake (jerryl@europa.com)
wrote:
>I have a field in my MySQL DB that is "DATE"
>
>on the form that populates this field, various
>people will by typing in dates in various formats
>
>how to I convert say 2/21/01 or 02-21-2001 etc...
>to 2001-02-21(MySQL Format)
probably the safest thing is instead of giving them a text field,
give them 3 drop downs for day month and year.