Extracts the seconds from a time value: SECOND() : SECOND « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. 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