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 the time zone of the app-server 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

Thu Sep 12 2024 16:00:00.000

[2]

Get the hour of the current time in UTC:

Query

Column1

         HOUR_NOW ( 'UTC' )
        

Input

Output

Result

Column1 : date

Thu Sep 12 2024 14: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

Thu Sep 12 2024 15: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

Thu Sep 12 2024 16:00:00.000