Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
The Celonis DATE
type represents timestamps. The supported timestamps range 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 in two ways. Supported are date string inputs using {d }
or integer inputs 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
Examples
Query
Filter
FILTER "Activities"."Eventtime" > {d '2018-02-15' } AND "Activities"."Eventtime" < {d '2018-05-15' };
Column1
"Activities"."Eventtime"
Input
Activities
Eventtime : DATE |
---|
Mon Jan 01 2018 00:00:00.000 |
Thu Feb 01 2018 00:00:00.000 |
Thu Mar 01 2018 00:00:00.000 |
Sun Apr 01 2018 00:00:00.000 |
Tue May 01 2018 00:00:00.000 |
Fri Jun 01 2018 00:00:00.000 |
Sun Jul 01 2018 00:00:00.000 |
Output
Result
Column1 : DATE |
---|
Thu Mar 01 2018 00:00:00.000 |
Sun Apr 01 2018 00:00:00.000 |
Tue May 01 2018 00:00:00.000 |