To Get a Date into MySql: there must be a better way.



MySql seems to only accept dates as 'yyyy-mm-dd'. How do I do that when the user might input dd/mm/yy, or d.m.yyyy (I'm in Europe)? I know I can do sscanf, or explode to rebuild the date string - but there must be a better way. Is there a FAQ somwhere?

tks.

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
.



Relevant Pages

  • Re: [PHP] date formatting
    ... wants the data to come down as yyyy-mm-dd. ... You could tell MySQL to use the mm-dd-yyyy input format I think. ... In PHP: ... Requires email confirmation. ...
    (php.general)
  • Re: [opensuse] Mysql question
    ... On Wed, April 11, 2007 17:54, Adam Tauno Williams wrote: ... YYYY-MM-DD. ... Is there anyway of changing Mysql's format? ... I don't EVER use MySQL; ...
    (SuSE)
  • Re: To Get a Date into MySql: there must be a better way.
    ... Tony Marston ... the user might input dd/mm/yy, or d.m.yyyy (I'm in Europe)? ... do sscanf, or explode to rebuild the date string - but there must be a ...
    (comp.lang.php)
  • Re: [opensuse] Mysql question
    ... I have records with the date in DD-MM-YYYY, ... YYYY-MM-DD. ... familiar with MySQL in terms of raw Transact-SQL, but in most cases you can ... I don't know if you're using a program or just SQL. ...
    (SuSE)
  • Re: [opensuse] Mysql question
    ... I have records with the date in DD-MM-YYYY, ... YYYY-MM-DD. ... Is there anyway of changing Mysql's format? ... I believe MySQL run there own mailing lists to deal with MySQL issues, ...
    (SuSE)