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] )
Time zone identifiers

The IANA Time Zone Database supports many different time zone names. Using Germany as an example, the time zone CET is the standard time zone and CEST is the daylight saving time zone. By using the uniform naming convention in the database, any daylight saving time will automatically be respected by MINUTE_NOW if the given country or area is currently in daylight saving time.

The uniform naming convention is structured as <area>/<location> which will represent a country or major area, for Germany that would be Europe/Berlin.

An error will be returned if the given <time_zone_id> is invalid or ambiguous.

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

Tue Aug 01 2023 12:47:00.000

[2]

Get the minute of the current time in UTC:

Query

Column1

         MINUTE_NOW ( 'UTC' )
        

Input

Output

Result

Column1 : date

Tue Aug 01 2023 10:47: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

Tue Aug 01 2023 11:47: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

Tue Aug 01 2023 12:47:00.000