Retrieve the seconds component from a datetime value.
SELECT SECOND(“2017-06-20 09:34:00.000023”); |
The SECOND() function retrieves the seconds component of a time or datetime value, ranging from 0 to 59.
SECOND(datetime) |
Parameter |
Description |
datetime |
Mandatory: The time or datetime value from which to extract the seconds. |
Works in: |
From MySQL version 4.0 |
Retrieve the seconds component from a specified time value.
SELECT SECOND(“23:59:59”); |