| Bug #2106 | minimum values for date and datetime | ||
|---|---|---|---|
| Submitted: | 12 Dec 2003 18:37 | Modified: | 12 Dec 2003 18:56 |
| Reporter: | Daniel Convissor | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | OS: | ||
| Assigned to: | Bugs System | CPU Architecture: | Any |
[12 Dec 2003 18:56]
Paul DuBois
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: The manual is correct as written. It says, "The *supported* range is...". While you *may* be able to use dates earlier than the supported lower limit, there is no guarantee.
Description: The documentation at http://www.mysql.com/doc/en/Column_types.html incorrectly specifies the minimum value allowed in DATE and DATETIME fields. The lowest accepted values (as tested on 3.23.56-log and 4.0.15-max-nt) are indicated below. DATE Docs say: "The supported range is '1000-01-01' to..." Actual Value: 0001-01-01 DATETIME Docs say: "The supported range is '1000-01-01 00:00:00' to..." Actual Value: 0001-01-01 00:00:00 How to repeat: CREATE TABLE t (dt datetime); -- Stated range INSERT INTO t VALUES ('1000-01-01 00:00:00'); -- Tested range INSERT INTO t VALUES ('0001-01-01 00:00:00'); select * from t; drop table t; CREATE TABLE u (dt date); -- Stated range INSERT INTO u VALUES ('1000-01-01'); -- Tested range INSERT INTO u VALUES ('0001-01-01'); select * from u; drop table u;