Show 

Home > DQL Guide > DQL Lexicon > hours

image\Dql_0023.gifhours

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.