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