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”); |