Bug #88685 Incorrect year in from_days documentation example
Submitted: 28 Nov 2017 21:09 Modified: 5 Dec 2017 2:13
Reporter: Kaitlin Mahar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5/5.6/5.7/8.0 OS:Any
Assigned to: CPU Architecture:Any

[28 Nov 2017 21:09] Kaitlin Mahar
Description:
The documentation says here https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-days  (and in earlier docs versions as well) 

that SELECT FROM_DAYS(730669) returns '2007-07-03'.

However, it actually returns '2000-07-03'. 

How to repeat:
Go to https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-days to see error, and execute command in MySQL  to verify actual result. 

Suggested fix:
Change to correct date.
[28 Nov 2017 21:32] MySQL Verification Team
Thank you for the bug report.
[5 Dec 2017 2:13] Paul DuBois
Posted by developer:
 
Example updated.