Open
Description
The usual format for an interval is INTERVAL 'value' unit
, but MySQL allows 'value'
to be an expression that is either a string or a number. For example:
SELECT DATE_SUB('2018-05-01',INTERVAL '1' YEAR);
SELECT DATE_SUB('2018-05-01',INTERVAL 1 YEAR);
both return 2017-05-01
. Currently, the latter syntax is not supported.
Metadata
Metadata
Assignees
Labels
No labels