Bug #101588 Docs about timezone offset for timestamps are not clear
Submitted: 12 Nov 2020 15:23 Modified: 20 Nov 2020 17:07
Reporter: Mark Callaghan Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0.22 OS:Any
Assigned to: CPU Architecture:Any

[12 Nov 2020 15:23] Mark Callaghan
The docs here state that the timezone offset is appended to the date part, but that is incorrect as it is appended to the time part. The examples on the doc page are clear about that.

This is valid, appending to time part: '2020-01-01 10:10:10-08:00'
This is not valid, appending to date part: '2020-01-01-08:00 10:10:10'

"As of MySQL 8.0.19, you can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table. The offset is appended to the date part of a datetime literal, with no intravening spaces, and uses the same format used for setting the time_zone system variable, with the following exceptions:"


How to repeat:
Read the docs

Suggested fix:
Update the docs
[12 Nov 2020 16:06] MySQL Verification Team
Thank you for the bug report.
[20 Nov 2020 17:07] Jon Stephens
Fixed in mysqldoc rev 68068.