DATE
Description
The Celonis DATE
type represents timestamps. We support timestamps from the start of the year 1400 to the end of the year 9999 with millisecond precision. Values outside this range are mapped to NULL
.
Date values can be defined as constants in two ways. We support date string inputs using {d }
or integer inputs with a count of milliseconds since 01.01.1970 using {t }
. Two formats are supported as date string input:
yyyy-MM-dd HH:mm:ss
yyyy-MM-dd
Examples
[1] Create DATE types using date strings and number of milliseconds: | ||||||||||
| ||||||||||
|
[2] | ||||||||||||||||
| ||||||||||||||||
|