Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5
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.