Skip to main content

Celonis Product Documentation

TODAY
Description

The TODAY function returns the current date in the specified timezone.

The time zone can be specified with a time zone id, like UTC, GMT+01 or Europe/Berlin. If no time zone is specified UTC is used.

Syntax
 TODAY( [time_zone_id] )

The <time_zone_id> parameter identifies the time zone as described here.

Example

[1]

Get the current date in UTC:

Query

Column1

         TODAY ( )
        

Input

Output

Result

Column1

Fri Oct 11 2024 00:00:00.000

[2]

Get the current date in the Australia/Sydney timezone:

Query

Column1

         TODAY ( 'Australia/Sydney' )
        

Input

Output

Result

Column1

Fri Oct 11 2024 00:00:00.000