Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

HOUR_NOW

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

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 GMT-08. If no time zone is specified the time zone of the app-server is used.

Syntax
HOUR_NOW ( [time_zone_id] ) 
Examples

[1] Get the hour of the current time on the app-server.

Query

Column1

HOUR_NOW ( )

Input

Output

Result

Column1 : DATE

Tue Dec 10 2019 14:00:00.000

[2] Get the hour of the current time in UTC.

Query

Column1

HOUR_NOW ( 'UTC' )

Input

Output

Result

Column1 : DATE

Fri Nov 20 2020 09:00:00.000

[3] Get the hour of the current time of the app-server in GMT+1.

Query

Column1

HOUR_NOW ( 'GMT+01:00' )

Input

Output

Result

Column1 : DATE

Fri Nov 20 2020 10:00:00.000