HOUR

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


HOUR (arithmetic_expression)

Description

The HOUR function returns the hour part of the time passed in the arithmetic_expression. The value returned ranges from 0 to 23.

Example

Supposing that we have the INVOICES table with a Delivery_Time field. To display the hour of the delivery time:


   SELECT HOUR(Delivery_Time)
     FROM INVOICES; 

See Also

MINUTE, SECOND.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next