You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
Activity
kyle-mccarthy commentedon Mar 16, 2022
I am running into this issue as well. mysql also allows for referencing columns in the unit part of the interval.
46bit commentedon Jun 9, 2022
ClickHouse similarly supports
INTERVAL 1 HOURwithout requiring the1to be quoted. I'm not sure it supports generic expressions though, just unquoted numbers. https://clickhouse.com/docs/en/sql-reference/operators/#intervalLucaCappelletti94 commentedon Sep 22, 2026
Closing as resolved in #517