Bug #17902 Support years < 1000 and >= -9999 for date/datetime data type
Submitted: 3 Mar 2006 17:17 Modified: 5 Mar 2006 8:58
Reporter: Matthew Schultz Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[3 Mar 2006 17:17] Matthew Schultz
Description:
Since mysql already supports dates ranging from 0000-01-01 to 9999-12-31, would it be possible to support the full iso 8601 date range to include negative years?  i.e. -9999-01-01 to -0001-12-31.  

How to repeat:
Insert a date with a negative year in a column set to the date/datetime data type.  Mysql does not recognize the date and sets it to the unknown value of 0000-00-00.

Suggested fix:
Allow negative years for date/datetime data types.
[3 Mar 2006 18:25] Matthew Schultz
The current supported date range for date/datetime data types is 1000-01-01 to 9999-12-31.  I propose increasing that range to -9999-01-01 to 9999-12-31 to adhere to the iso 8601 standard.
[3 Mar 2006 18:26] Matthew Schultz
Editing Synopsis for better description.
[5 Mar 2006 8:58] Valeriy Kravchuk
Thank you for a reasonable feature request.