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: | |
Category: | MySQL Server: Data Types | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[3 Mar 2006 17:17]
Matthew Schultz
[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.