Skip to main content

Celonis Product Documentation

HOUR_NOW
Description

The HOUR_NOW function returns the hour 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, UTC is used.

Syntax
 HOUR_NOW ( [time_zone_id] )

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

Examples

[1]

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

Query

Column1 

         HOUR_NOW ( )

Input

Output

Result

Column1 : date

Fri Oct 11 2024 12:00:00.000

[2]

Get the hour of the current time in UTC:

Query

Column1 

         HOUR_NOW ( 'UTC' )

Input

Output

Result

Column1 : date

Fri Oct 11 2024 12:00:00.000

[3]

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

Query

Column1 

         HOUR_NOW ( 'GMT+01:00' )

Input

Output

Result

Column1 : date

Fri Oct 11 2024 13:00:00.000

[4]

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

Query

Column1 

         HOUR_NOW ( 'Europe/Berlin' )

Input

Output

Result

Column1 : date

Fri Oct 11 2024 14:00:00.000