v.23.9Improvement

Enhance INTERVAL Literals to Support Plural Forms

Official CH changelog text
Make it possible to use plural when using interval literals. INTERVAL 2 HOURS should be equivalent to INTERVAL 2 HOUR. #54860 (Jordi Villar).
Added support for plural forms in interval literals, allowing expressions like INTERVAL 2 HOURS to be equivalent to INTERVAL 2 HOUR.

Why it matters

This feature improves the usability and flexibility of interval literals by allowing users to specify the unit in plural form without causing errors or requiring manual singular conversion, making query writing more natural and user-friendly.

How to use it

Simply use plural forms when specifying interval units in literals, for example: INTERVAL 2 HOURS. The system will interpret it identically to the singular form INTERVAL 2 HOUR.

Related resources

PreviousNext