HOUR_NOW
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
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. (Since: CELONIS 4.7)
Examples
[1] Get the hour of the current time on the app server. |
[2] Get the hour of the current time in UTC.
|
[3] Get the hour of the current time in GMT+1.
|
[4] Get the hour of the current time in time zone
|