Extracts the seconds from a time value: SECOND(






Extracts the seconds from a time value: SECOND(

    
mysql>
mysql>
mysql> SELECT SECOND('2004-12-31 23:59:59');
+-------------------------------+
| SECOND('2004-12-31 23:59:59') |
+-------------------------------+
|                            59 |
+-------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
  








Related examples in the same category

1.Get the hour, minute and second time components