TIME
This page is part of MariaDB's Documentation.
The parent of this page is: Data Types for MariaDB Enterprise Server
Topics on this page:
Overview
Hours, minutes, seconds.
EXAMPLES
CREATE TABLE time_example (
description VARCHAR(30),
example TIME(6)
);
INSERT INTO time_example VALUES
('HH:MM:SS', '12:34:56'),
('HHMMSS', '123456'),
('SS.microsec', '42.123456');
The resulting data would look like this:
SELECT * FROM time_example;
+-------------+-----------------+
| description | example |
+-------------+-----------------+
| HH:MM:SS | 12:34:56.000000 |
| HHMMSS | 12:34:56.000000 |
| SS.microsec | 00:00:42.123456 |
+-------------+-----------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.