This function returns the hour part of a timestamp based on a given time zone.
Syntax
hour(timestamp, timeZone) #Output: Number
Use cases and examples
Use case |
---|
No content found. |
This function returns the hour part of a timestamp based on a given time zone.
hour(timestamp, timeZone) #Output: Number
Parser expression | Description |
---|---|
%{hour({issue.created}, RUN_AS_LOCAL)} | This example returns the hour part of the issue creation date. If the issue was created on March 25th, 2020 23:15 the output would be 23. |
%{hour(stringToDate("2020-01-01 00:30","Europe/Berlin"),"UTC")} | This example returns the hour part of the given date, the timezone is UTC. Due to the time zone UTC, the output will be 23. |
Parameters used in this function
Parameter | Input (data type) | Description |
---|---|---|
timestamp | NUMBER | The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date). |
timeZone | TIMEZONE | The time zone used for the calculation. |
Hours depend on the time zone - it might be 1 PM on the west coast of the US while at the same time it's already 8 PM in Germany.
This function returns a NUMBER
Use case |
---|
No content found. |
Powered by Atlassian Confluence 8.5.12, themed by Refined 7.6.0 and Decadis AG