| Bug #29646 | "1982-02-29" supposed to be an invalid date, but can be defined as a valid date | ||
|---|---|---|---|
| Submitted: | 9 Jul 2007 12:23 | Modified: | 9 Jul 2007 12:40 |
| Reporter: | Gökçe Ketenci | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Data Types | Severity: | S2 (Serious) |
| Version: | 4.1.20 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[9 Jul 2007 12:40]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php See also http://dev.mysql.com/doc/refman/4.1/en/datetime.html
[9 Jul 2007 12:42]
Sveta Smirnova
This behaviour has been changed in version 5.0. See also http://dev.mysql.com/doc/refman/5.0/en/datetime.html since words "As of 5.0.2, the server requires that month and day values be legal"
Description: "1982-02-29" supposed to be an invalid date, but can be defined as a valid date How to repeat: execute query below: select date('1982-02-29');