Syntax
TIME_TO_SEC(time)
Purpose
You can call this function to convert a timestamp argument time into seconds.
Examples
obclient> SELECT TIME_TO_SEC('22:23:00');
+-------------------------+
TIME_TO_SEC('22:23:00')
+-------------------------+
80580
+-------------------------+
1 row in set (0.00 sec)
obclient> SELECT TIME_TO_SEC('00:39:38');
+-------------------------+
TIME_TO_SEC('00:39:38')
+-------------------------+
2378
+-------------------------+
1 row in set (0.00 sec)