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.
Time zone identifiers
The IANA Time Zone Database supports many different time zone names. Using Germany as an example, the time zone CET
is the standard time zone and CEST
is the daylight saving time zone. By using the uniform naming convention in the database, any daylight saving time will automatically be respected by the operator if the given country or area is currently in daylight saving time.
The uniform naming convention is structured as <area>/<location>
which will represent a country or major area, for Germany that would be Europe/Berlin
.
Valid time zone abbreviations are:
CET
CST6CDT
EET
EST5EDT
GB
GMT
GMT0
NZ
NZ-CHAT
MET
MST7MDT
PRC
PST8PDT
ROK
UCT
UTC
W-SU
WET
An error will be returned if the given time zone identifier is invalid or ambiguous.