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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to