DateTime projection
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
DateTime Projection Functions contains functions to extract the different parts from a DATE and to map DATEs to other data types and vice versa.
MILLIS, SECONDS, HOURS, DAY, MONTH and YEAR extract the corresponding date part from a DATE.
CALENDAR_WEEK, DAY_OF_WEEK and QUARTER return the corresponding information about a DATE.
DATE_MATCH checks whether a DATE matches a specified pattern.
REMAP_TIMESTAMPS counts time units in specified intervals.
TO_TIMESTAMP converts a string into a DATE.