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:
None 
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
Description:
(1) I attempted to enter B.C. dates such as the birth and death of Aristotle.

(2) I expected MySQL to accept such dates.

(3) The following confirmed that MySQL is currently incapable of storing such dates:

Eric Braswell
Web Manager     MySQL AB
Cupertino, USA

How to repeat:
N/A

Suggested fix:
Use Julian dating mechanism or alternative.
[2 Dec 2006 12:59] Miguel Solorzano
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.