TIME_TO_SEC
Syntax
TIME_TO_SEC(time)
Description
Returns the time argument, converted to seconds.
The value returned by TIME_TO_SEC
is of type DOUBLE
. Before MariaDB 5.3 (and MySQL 5.6), the type was INT
. The returned value preserves microseconds of the argument. See also Microseconds in MariaDB.
Examples
SELECT TIME_TO_SEC('22:23:00'); +-------------------------+ | TIME_TO_SEC('22:23:00') | +-------------------------+ | 80580 | +-------------------------+
SELECT TIME_TO_SEC('00:39:38'); +-------------------------+ | TIME_TO_SEC('00:39:38') | +-------------------------+ | 2378 | +-------------------------+
SELECT TIME_TO_SEC('09:12:55.2355'); +------------------------------+ | TIME_TO_SEC('09:12:55.2355') | +------------------------------+ | 33175.2355 | +------------------------------+ 1 row in set (0.000 sec)
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.