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:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Bugs System CPU Architecture:Any
Triage: D4 (Minor)

[12 Dec 2003 18:37] Daniel Convissor
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;
[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.