Hour 24 (Expression Function)

Purpose

The Hour 24 function (HOUR_24) generates a number that represents the hour in a 24 hour clock for a timestamp provided in a given timezone.

Parameters

The Hour 24 function has two parameters, one of which is required:

Timestamp

Allowed Inputs: field value or a number representing a Unix timestamp.

There are several sources of Unix timestamps available. For example the stored value of a date or date time field is a Unix timestamp. Also When using the advanced interface the output of the date or date time expression function is a Unix timestamp.

Timezone

Allowed Inputs: field value or a text string

The second optional parameter of the Hour 24 function is a string that represents the timezone. Either use the query builder to choose a field that contains the value or use type a value to enter a number. The value should be based on the tz (timezone) database used by Linux and other Unix system in the form “Area/Location” e.g. “America/New_York”. If no value is provided then the current user's timezone is used.

Output

The output of the Hour 24 function is number representing the hour in a 24 hour clock for the value of the timestamp provided in a given timezone.

Example

For example HOUR_24(1349047828,“America/New_York”) would result in “19” and HOUR_24(1349047828,“Asia/Tokyo”)(1349047828,“Asia/Tokyo”) would result in “8”.

expression function - hour 24.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024