The hours function extracts the hour from a time value expressed in a 24-hour format.

TIME VALUE

DataEase time value formatted hh:mm:ss.

Examples

hours(12:00:00) {midday}

Returns:12

hours(23:59:00) {one minute before midnight}

Returns:23

Note: The bracketed text above (e.g., midday) is used to clarify the time of day only; it is not one of the function's parameters.

hours

Type

Time Function

Purpose

The hours function extracts the hour from a time value expressed in a 24-hour format.

Syntax

hours( TIME VALUE)

Returns

An integer value from 00 to 23.

Examples

hours(12:00:00) {midday}

Returns:12

hours(23:59:00) {one minute before midnight}

Returns:23

Note: The bracketed text above (e.g., midday) is used to clarify the time of day only; it is not one of the function's parameters.