4D v13.4

HOUR

Home

 
4D v13.4
HOUR

HOUR  


 

 

 HOUR (arithmetic_expression)

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;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

MINUTE
SECOND