TIME
name
TIME
description
TIME type
Time type, can appear as a query result, does not support table storage for the time being. The storage range is [-838:59:59, 838:59:59].
Currently in Doris, the correctness of TIME as a result of calculations is guaranteed (e.g., functions such as timediff), but manual CAST generation of the TIME type is not recommended.
The calculation of TIME type in constant folding is prohibited.
example
mysql> select timediff('2020-01-01 12:05:03', '2020-01-01 08:02:15');
+------------------------------------------------------------------------------------------------------+
| timediff(cast('2020-01-01 12:05:03' as DATETIMEV2(0)), cast('2020-01-01 08:02:15' as DATETIMEV2(0))) |
+------------------------------------------------------------------------------------------------------+
| 04:02:48 |
+------------------------------------------------------------------------------------------------------+
1 row in set (0.12 sec)
mysql> select timediff('2020-01-01', '2000-01-01');
+------------------------------------------------------------------------------------+
| timediff(cast('2020-01-01' as DATETIMEV2(0)), cast('2000-01-01' as DATETIMEV2(0))) |
+------------------------------------------------------------------------------------+
| 838:59:59 |
+------------------------------------------------------------------------------------+
1 row in set (0.11 sec)keywords
TIME