At 16:43 -0500 2/14/03, Don Vu wrote:
Is it just me, or does Mysql allow invalid dates to be entered into
columns with date datatype? I found some data that blew up in a perl
script when doing some date manipulation, and it turns out I have
invalid dates in my database, such as June 31, 2003.
On 14 Feb 2003, at 16:43, Don Vu wrote:
Is it just me, or does Mysql allow invalid dates to be entered into
columns with date datatype?
See the documentation (http://www.mysql.com/doc/en/DATETIME.html):
The MySQL server only performs basic checking on the validity of
a date: days
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original
At 16:55 -0500 2/14/03, Peter Grigor wrote:
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.
It can be argued either way. You could just as well consider it a
bug that you try
]; Don Vu
[EMAIL PROTECTED]; MySQL Mailing List (E-mail)
[EMAIL PROTECTED]
Sent: Friday, February 14, 2003 4:59 PM
Subject: Re: Invalid Date Bug
At 16:55 -0500 2/14/03, Peter Grigor wrote:
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug
over speed but that's just me...
take care,
d
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 5:00 PM
To: Peter Grigor; Don Vu; MySQL Mailing List (E-mail)
Subject: Re: Invalid Date Bug
At 16:55 -0500 2/14/03, Peter Grigor wrote:
Yep, you're