Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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>