Re: New to Dates - Plain English Please

[Paul DuBois]

At 23:40 -0700 6/21/04, David Blomstrom wrote:
>I  haven't worked with dates yet and wondered if
>someone could give me an overview in plain English.
>
>At the moment, I'm working on a table with a column of
>dates in this format:
>
>March 2, 2003
>July 7, 2004
>
>If I understand the Manual, the correct format for
>these dates in a MySQL table would be like this:
>
>03-02-2003
>07-07-2004
>
>Am I right?

No.  Which part of the manual leads you to believe that this
is the correct format for dates?

Dates should be entered in YYYY-MM-DD format, not MM-DD-YYYY.

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com