Bug #90005 INTERVAL syntax is not described in proper place
Submitted: 11 Mar 2018 11:07 Modified: 10 Nov 2018 22:06
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[11 Mar 2018 11:07] Federico Razzoli 
Description:
The syntax of INTERVAL keyword is explained in DATE_ADD() setion:

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-add

However this syntax is independent, meaning that we can do something like:

SELECT NOW() + 7 DAY;

Thus I believe that it deserves a page on its own, probably in chapter "Language structure".

How to repeat:
Look for that syntax in the documentation pretending that you don't know where it is.
[12 Mar 2018 4:44] MySQL Verification Team 
Hello Federico,

Thank you for the report and feedback!

Thanks,
Umesh
[12 Mar 2018 7:45] Federico Razzoli 
There is a typo in the original description. I meant that we are able to do something like this:

SELECT NOW() + INTERVAL 7 DAY;
[10 Nov 2018 22:06] Paul DuBois 
Posted by developer:
 
Revised:

https://dev.mysql.com/doc/refman/8.0/en/expressions.html