Bug #24775 | MySQL does not store B.C. dates | ||
---|---|---|---|
Submitted: | 2 Dec 2006 12:43 | Modified: | 2 Dec 2006 12:59 |
Reporter: | Philip G. Duffy | Email Updates: | |
Status: | Unsupported | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | All | OS: | Any (All) |
Assigned to: | CPU Architecture: | Any |
[2 Dec 2006 12:43]
Philip G. Duffy
[2 Dec 2006 12:59]
MySQL Verification Team
Thank you for the bug report. The range of date supported is according the Manual: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html # DATE A date. The supported range is '1000-01-01' to '9999-12-31'. MySQL displays DATE values in 'YYYY-MM-DD' format, but allows you to assign values to DATE columns using either strings or numbers.