Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
The Celonis DATE type supports timestamps ranging from the year 1400 (including) to the year 10000 (excluding) on millisecond precision. Values outside this range will be mapped to null.
Date values can be defined as constants either with a date string input using {d }
or with a count of milliseconds since 01.01.1970 using {t }
.
The following two formats are supported as date string input:
- yyyy-MM-dd HH:mm:ss
- yyyy-MM-dd
Example
Creating DATE types using date strings and number of milliseconds:
Query
Column1
{t 0}
Column2
{d'1970-01-02'}
Column3
{d'1970-01-03 00:00:00'}
Input
To create a date constant TO_TIMESTAMP can be used.