Bug #112190 Date range (fractional part) DATETIME/TIMESTAMP documented inconsistent

• Submitted: 27 Aug 2023 13:30
• Modified: 28 Aug 2023 8:25
• Reporter: William Chiquito
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any
• Tags: 5.7, 8.0

[27 Aug 2023 13:30] William Chiquito

Description:
In the documentation (5.7 and 8.0) it's inconsistently stated:

11.2.1 Date and Time Data Type Syntax (https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html and https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html):

DATETIME[(fsp)]
"The supported range is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'.".

TIMESTAMP[(fsp)]
"The range is '1970-01-01 00:00:01.000000' UTC to '2038-01-19 03:14:07.999999' UTC.".

but

11.2.2 The DATE, DATETIME, and TIMESTAMP Types (https://dev.mysql.com/doc/refman/5.7/en/datetime.html and https://dev.mysql.com/doc/refman/8.0/en/datetime.html):

"...  the range for DATETIME values is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.499999', and the range for TIMESTAMP values is '1970-01-01 00:00:01.000000' to '2038-01-19 03:14:07.499999'.".

How to repeat:
See the documentation.

[28 Aug 2023 5:42] MySQL Verification Team

Hello William,

Thank you for the report and feedback.

regards,
Umesh

[28 Aug 2023 8:25] Stefan Hinz

Posted by developer:
 
Typo fixed. Thanks for spotting and reporting!