Skip to main content

Celonis Product Documentation

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:

Query

Column1

         {t 0 }
        

Column2

         {d '1970-01-02' }
        

Column3

         {d '1970-01-03 00:00:00' }
        

Input

Output

Result

Column1 : date

Column2 : date

Column3 : date

Thu Jan 01 1970 00:00:00.000

Fri Jan 02 1970 00:00:00.000

Sat Jan 03 1970 00:00:00.000

[2]

Filter activities by a DATE interval:

Query

Filter

         FILTER "Activities"."Eventtime" > {d '2018-02-15' } AND "Activities"."Eventtime" < {d '2018-05-15' };
        

Column1

         "Activities"."Eventtime"
        

Input

Output

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

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

See also: