Modulo Function Support for Date and DateTime Types

Why it matters

This feature enables users to perform modulo operations directly on date and datetime values, expanding the arithmetic capabilities of these data types and allowing for more flexible temporal data processing.

How to use it

Use the modulo operator (%) with Date or DateTime columns or values in your queries, for example:

SELECT event_date % 7 FROM events;