Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Allow plural time units in interval literals. For example, currently, Calcite allows INTERVAL '2' DAY but gives an error for INTERVAL '2' DAYS. (Note: DAY vs DAYS.)
Standard SQL only allows the first; PostgreSQL allows both.