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] ) 
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 HOUR_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.

Examples

[1]

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

Query

Column1

         HOUR_NOW ( )
        

Input

Output

Result

Column1 : date

Wed Sep 14 2022 10:00:00.000

[2]

Get the hour of the current time in UTC:

Query

Column1

         HOUR_NOW ( 'UTC' )
        

Input

Output

Result

Column1 : date

Wed Sep 14 2022 08: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

Wed Sep 14 2022 09: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

Wed Sep 14 2022 10:00:00.000