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. Of course June never has 31 days.
Is this a known bug? honestly, this seems like a pretty basic thing to validate. Is there a patch/fix for it?
It's by design. MySQL does only minimal validation of date values for maximum server speed.
Validate your dates on the client end. If, as you say, it's a pretty basic thing, it shouldn't be too difficult. :-) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
