TIME

Syntax:

TIME [()]

Microsecond precision can be from 0-6; If not specified 0 is used. Microseconds is available since MariaDB 5.3.

Description:

A time. The range is '-838:59:59.999999' to '838:59:59.999999'. MariaDB displays TIME values in 'HH:MM:SS.ssssss' format, but allows assignment of values to TIME columns using either strings or numbers.

Examples:

MariaDB [test]> CREATE TABLE time (t TIME);
Query OK, 0 rows affected (0.27 sec)

MariaDB [test]> INSERT INTO time VALUES ('90:00:00'),('800:00:00');
Query OK, 2 rows affected (0.23 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> INSERT INTO time VALUES (800);
Query OK, 1 row affected (0.12 sec)

MariaDB [test]> SELECT * FROM time;
+-----------+
| t         |
+-----------+
| 90:00:00  |
| 800:00:00 |
| 00:08:00  |
+-----------+
3 rows in set (0.00 sec)

MariaDB [test]>