SELECT TIME_TO_SEC('00:39:38'); : TIME_TO_SEC « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. TIME_TO_SEC
mysql>
mysql>
mysql> SELECT TIME_TO_SEC('00:39:38');
+-------------------------+
| TIME_TO_SEC('00:39:38') |
+-------------------------+
|                    2378 |
+-------------------------+
1 row in set (0.00 sec)

mysql>








14.49.TIME_TO_SEC
14.49.1.TIME_TO_SEC(time) returns the time argument, converted to seconds.
14.49.2.SELECT TIME_TO_SEC('00:39:38');