Skip to main content
Skip to main content

TIME

TIME​

name​

TIME

description​

TIME type TIME type that can appear as a query result. Table storage and manual CAST generation are not supported. When calculating without constant folding, it could represent [-838:59:59, 838:59:59]。

example​

mysql [(none)]> select timediff('2020-01-01', '2000-01-01');
+--------------------------------------------------------+
| timediff('2020-01-01 00:00:00', '2000-01-01 00:00:00') |
+--------------------------------------------------------+
| 175320:00:00 |
+--------------------------------------------------------+
1 row in set (0.00 sec)

keywords​

TIME