DateTime
Description
This section includes a variety of datetime functions.
Datetime Calendars allow to use a restricted date calculation based on the specified calendar configuration.
DateTime Constant Functions allow to use the current date or time in a query.
DateTime Difference Functions can be used to calculate the time difference between two DATEs.
DateTime Modification Functions can be used to modify DATEs.
DateTime Projection Functions contains functions to extract the different parts from a DATE and to map DATEs to other data types and vice versa.
DateTime Rounding Functions can be used to round DATE values.
TIMELINE_COLUMN and TIMELINE_TABLE can be used to create a continuous timeline for a given time unit (e.g., days). They can be used to aggregate values from one or multiple tables onto one common time axis.