Skip to main content

Celonis Product Documentation

MINUTE_NOW
Description

The MINUTE_NOW function returns the minute of the current time of the app-server in the specified time zone.

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

Syntax
 MINUTE_NOW ( [time_zone_id] )

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

Operator Performance

As the result of MINUTE_NOW has to be recalculated every time the filter changes, using MINUTE_NOW excessively can have a negative impact on query performance. We therefore recommend to only use the function where necessary.

Examples

[1]

Get the minute of the current time on the app-server:

Query

Column1

         MINUTE_NOW ( )
        

Input

Output

Result

Column1 : date

Thu Sep 12 2024 16:42:00.000

[2]

Get the minute of the current time in UTC:

Query

Column1

         MINUTE_NOW ( 'UTC' )
        

Input

Output

Result

Column1 : date

Thu Sep 12 2024 14:42:00.000

[3]

Get the minute of the current time in GMT+1:

Query

Column1

         MINUTE_NOW ( 'GMT+01:00' )
        

Input

Output

Result

Column1 : date

Thu Sep 12 2024 15:42:00.000

[4]

Get the minute of the current time in time zone Europe/Berlin, respecting possible daylight saving:

Query

Column1

         MINUTE_NOW ( 'Europe/Berlin' )
        

Input

Output

Result

Column1 : date

Thu Sep 12 2024 16:42:00.000