[PHP] date format for MySQL
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) Jerry Lake- [EMAIL PROTECTED] Web Designer Europa Communications - http://www.europa.com Pacifier Online - http://www.pacifier.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] date format for MySQL
On Wed, 21 Feb 2001 11:36:02 -0800, Jerry Lake ([EMAIL PROTECTED]) 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]