SECOND

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

version 11


SECOND (arithmetic_expression)

Description

The SECOND function returns the seconds part (ranging from 0 to 59) of the time passed in the arithmetic_expression.

Example

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

   SELECT SECOND(Delivery_Time)
     FROM INVOICES; 

See Also

HOUR, MINUTE.


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