Date and time macros

Discover the available macros to work with date and time in CQL.

Croct's mascot winking
Looking for something specific?

Use the search bar at the top of the page or press / to quickly search through the documentation.

Use the summary below to quickly jump to a specific topic:

PageDescription
Current periodLearn how to get the current week, month, or year.
Ellapsed timeLearn how to calculate the elapsed time between two date-time values.