Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## HOUR

> Returns the hour in the argument as a short integer value in the range of 0–23.

> #### Syntax

>     HOUR ( time_expression )

> Example

> This example illustrates the `HOUR` function:

>     SELECT *
>         FROM arrivals
>         WHERE HOUR (in_time) < 12 ;

> #### Notes

> - The argument to the function must be of type `TIME`.

> - The argument must be specified in the format `hh:mi:ss`.

> - The result is of type `SHORT`.

> - If the argument expression evaluates to `NULL`, the result is `NULL`.

> ##### Compatibility

> ODBC compatible

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095