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:00' or 'GMT-8'. 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 of 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 of the app-server in UTC:
Query
Column1
HOUR_NOW( 'UTC' )
Input
Output
Result
Column1 : DATE |
---|
Tue Dec 10 2019 13: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 |
---|
Tue Dec 10 2019 14:00:00.000 |