Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SECOND(time) returns the second for time, in the range 0 to 59

mysql> mysql> SELECT SECOND('11:05:03'); +--------------------+ | SECOND('11:05:03') | +--------------------+ |                  3 | +--------------------+ 1 row in set (0.00 sec) mysql>