Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Extracts the seconds from a time value
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>