This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new a46e9f645ca [enhancement](datatype) Add TIME docs (#998)
a46e9f645ca is described below
commit a46e9f645cae8b8035b21123e81422dcf26e6c0b
Author: zclllhhjj <[email protected]>
AuthorDate: Sat Aug 24 15:58:42 2024 +0800
[enhancement](datatype) Add TIME docs (#998)
only doc changes, no code.
decide to prohibit cast from datelike to numeric types. not recommended
now. so no relative examples.
---
docs/sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
docs/sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 9 ++--
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 6 ++-
.../sql-manual/sql-reference/Data-Types/TIME.md} | 30 ++++++-----
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 6 ++-
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 6 ++-
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 6 ++-
sidebars.json | 1 +
.../sql-manual/sql-reference/Data-Types/DATE.md | 5 +-
.../sql-manual/sql-reference/Data-Types/TIME.md | 32 ++++++-----
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 9 ++--
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 9 ++--
.../sql-manual/sql-data-types/date-time/DATE.md | 3 +-
.../sql-data-types/date-time/DATETIME.md | 4 +-
.../sql-manual/sql-data-types/date-time/TIME.md | 62 ++++++++++++++++++++++
.../sql-data-types/date-time/datetime-overview.md | 9 ++--
versioned_sidebars/version-1.2-sidebars.json | 1 +
versioned_sidebars/version-2.0-sidebars.json | 1 +
versioned_sidebars/version-2.1-sidebars.json | 1 +
versioned_sidebars/version-3.0-sidebars.json | 1 +
40 files changed, 603 insertions(+), 81 deletions(-)
diff --git a/docs/sql-manual/sql-data-types/date-time/DATE.md
b/docs/sql-manual/sql-data-types/date-time/DATE.md
index 3a7be464b5f..40017e4a115 100644
--- a/docs/sql-manual/sql-data-types/date-time/DATE.md
+++ b/docs/sql-manual/sql-data-types/date-time/DATE.md
@@ -34,7 +34,8 @@ date
Date type, the current range of values is ['0000-01-01','9999-12-31'], and the
default print form is 'yyyy-MM-dd'.
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git a/docs/sql-manual/sql-data-types/date-time/DATETIME.md
b/docs/sql-manual/sql-data-types/date-time/DATETIME.md
index 37808f036ff..5d076b7946c 100644
--- a/docs/sql-manual/sql-data-types/date-time/DATETIME.md
+++ b/docs/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -38,14 +38,14 @@ The form of printing is 'yyyy-MM-dd HH:mm:ss.SSSSSS'
### note
-DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the
[Nereids](../../../query-acceleration/nereids) on, decimals exceeding the
current precision will be **rounded**.
+DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the [Nereids](/docs/query/nereids/nereids-new)
on, decimals exceeding the current precision will be **rounded**.
Inserting a DATETIME value with a fractional seconds part into a column of the
same type but having fewer fractional digits results in **rounded**.
DATETIME reads support resolving the time zone in the format of the original
DATETIME literal followed by the time zone:
```sql
<date> <time>[<timezone>]
```
-For the specific supported formats for `<timezone>`, see
[timezone](../../../advanced/time-zone). Note that the `DATE`, `DATEV2`,
`DATETIME`, and `DATETIMEV2` types **don't** contain time zone information. For
example, if an input time string "2012-12-12 08:00:00+08:00" is parsed and
converted to the current time zone "+02:00", and the actual value "2012-12-12
02:00:00" is stored in the DATETIME column, the value itself will not change,
no matter how much the cluster environment variable [...]
+For the specific supported formats for `<timezone>`, see
[timezone](../../../admin-manual/cluster-management/time-zone). Note that the
`DATE`, `DATEV2`, `DATETIME`, and `DATETIMEV2` types **don't** contain time
zone information. For example, if an input time string "2012-12-12
08:00:00+08:00" is parsed and converted to the current time zone "+02:00", and
the actual value "2012-12-12 02:00:00" is stored in the DATETIME column, the
value itself will not change, no matter how much the clust [...]
### example
diff --git a/docs/sql-manual/sql-data-types/date-time/TIME.md
b/docs/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..2fcb056d3b3
--- /dev/null
+++ b/docs/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 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
+
+```sql
+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
diff --git a/docs/sql-manual/sql-data-types/date-time/datetime-overview.md
b/docs/sql-manual/sql-data-types/date-time/datetime-overview.md
index 826a714b887..20d2f9f4e51 100644
--- a/docs/sql-manual/sql-data-types/date-time/datetime-overview.md
+++ b/docs/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,11 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### Description
+Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp) . The
result of directly converting them as numeric types as not guaranteed.
-The date data types include DATE and DATETIME:
-
-- **[DATE](../datetime/DATE.md)**: It stores only the date. The minimum
precision unit is days.
-
-- **[DATETIME](../datetime/DATETIME.md)**: It stores both the date and time.
The minimum precision unit is milliseconds.
\ No newline at end of file
+For more information refer to [DATE](./DATE), [TIME](./TIME) and
[DATETIME](./DATETIME) documents.
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATE.md
index b79b042e271..b3da85fd423 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATE.md
@@ -35,7 +35,8 @@ DATE
日期类型，目前的取值范围是['0000-01-01', '9999-12-31'], 默认的打印形式是'yyyy-MM-dd'
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATETIME.md
index 244c484a837..fb0a0c09bfe 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -37,7 +37,7 @@ DATETIME([P])
### note
-DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](/docs/query/nereids/nereids-new)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
将带有小数秒部分的 DATETIME 值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
@@ -45,7 +45,7 @@ DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧
<date> <time>[<timezone>]
```
-关于`<timezone>`的具体支持格式，请见[时区](../../../advanced/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
+关于`<timezone>`的具体支持格式，请见[时区](../../../admin-manual/cluster-management/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
### example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/TIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..bc33374035d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## TIME
+
+### name
+
+TIME
+
+### description
+
+TIME 类型
+ 时间类型，可以作为查询结果出现，暂时不支持建表存储。表示范围为 `[-838:59:59, 838:59:59]`。
+ 当前 Doris 中，TIME 作为计算结果的正确性是有保证的（如 `timediff` 等函数），但**不推荐手动 CAST 产生 TIME
类型**。
+ TIME 类型不会在常量折叠中进行计算。
+
+### example
+
+```sql
+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
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/datetime-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/datetime-overview.md
index 9dd6f7d3046..65b696db3ad 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,8 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### 描述
+日期类型包括 DATE、TIME 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。TIME
类型只存储时间，且**暂时不支持建表存储，只能在查询过程中使用**。
-日期类型包括 DATE 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。
+对日期类型进行计算，或将其转换为数字，请使用类似
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp)
等函数，直接将其 CAST 为数字类型的结果不受保证。在未来的版本中，此类 CAST 行为将会被禁止。
-更多信息参考 [DATE](../datetime/DATE.md)、[DATETIME](../datetime/DATETIME.md) 文档。
\ No newline at end of file
+更多信息参考 [DATE](./DATE)、[TIME](./TIME) 和 [DATETIME](./DATETIME) 文档。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/TIME.md
similarity index 57%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/TIME.md
index b79b042e271..7f47bd14da8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/TIME.md
@@ -1,6 +1,6 @@
---
{
- "title": "DATE",
+ "title": "TIME",
"language": "zh-CN"
}
---
@@ -24,26 +24,30 @@ specific language governing permissions and limitations
under the License.
-->
-## DATE
+## TIME
### name
-DATE
+TIME
### description
- DATE类型
- 日期类型，目前的取值范围是['0000-01-01', '9999-12-31'], 默认的打印形式是'yyyy-MM-dd'
+
+TIME 类型
+ 时间类型，可以作为查询结果出现，不支持建表存储与手动 CAST 产生。
+ 当不使用常量折叠进行计算时，表示范围为 `[-838:59:59, 838:59:59]`。
### example
-```
-SELECT DATE('2003-12-31 01:02:03');
-+-----------------------------+
-| DATE('2003-12-31 01:02:03') |
-+-----------------------------+
-| 2003-12-31 |
-+-----------------------------+
+
+```sql
+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
- DATE
+ TIME
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
index b79b042e271..b3da85fd423 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
@@ -35,7 +35,8 @@ DATE
日期类型，目前的取值范围是['0000-01-01', '9999-12-31'], 默认的打印形式是'yyyy-MM-dd'
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
index 244c484a837..fb0a0c09bfe 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -37,7 +37,7 @@ DATETIME([P])
### note
-DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](/docs/query/nereids/nereids-new)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
将带有小数秒部分的 DATETIME 值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
@@ -45,7 +45,7 @@ DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧
<date> <time>[<timezone>]
```
-关于`<timezone>`的具体支持格式，请见[时区](../../../advanced/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
+关于`<timezone>`的具体支持格式，请见[时区](../../../admin-manual/cluster-management/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
### example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/TIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..bc33374035d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## TIME
+
+### name
+
+TIME
+
+### description
+
+TIME 类型
+ 时间类型，可以作为查询结果出现，暂时不支持建表存储。表示范围为 `[-838:59:59, 838:59:59]`。
+ 当前 Doris 中，TIME 作为计算结果的正确性是有保证的（如 `timediff` 等函数），但**不推荐手动 CAST 产生 TIME
类型**。
+ TIME 类型不会在常量折叠中进行计算。
+
+### example
+
+```sql
+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
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
index 9dd6f7d3046..65b696db3ad 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,8 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### 描述
+日期类型包括 DATE、TIME 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。TIME
类型只存储时间，且**暂时不支持建表存储，只能在查询过程中使用**。
-日期类型包括 DATE 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。
+对日期类型进行计算，或将其转换为数字，请使用类似
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp)
等函数，直接将其 CAST 为数字类型的结果不受保证。在未来的版本中，此类 CAST 行为将会被禁止。
-更多信息参考 [DATE](../datetime/DATE.md)、[DATETIME](../datetime/DATETIME.md) 文档。
\ No newline at end of file
+更多信息参考 [DATE](./DATE)、[TIME](./TIME) 和 [DATETIME](./DATETIME) 文档。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
index b79b042e271..b3da85fd423 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
@@ -35,7 +35,8 @@ DATE
日期类型，目前的取值范围是['0000-01-01', '9999-12-31'], 默认的打印形式是'yyyy-MM-dd'
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
index 244c484a837..fb0a0c09bfe 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -37,7 +37,7 @@ DATETIME([P])
### note
-DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](/docs/query/nereids/nereids-new)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
将带有小数秒部分的 DATETIME 值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
@@ -45,7 +45,7 @@ DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧
<date> <time>[<timezone>]
```
-关于`<timezone>`的具体支持格式，请见[时区](../../../advanced/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
+关于`<timezone>`的具体支持格式，请见[时区](../../../admin-manual/cluster-management/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
### example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/TIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..bc33374035d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## TIME
+
+### name
+
+TIME
+
+### description
+
+TIME 类型
+ 时间类型，可以作为查询结果出现，暂时不支持建表存储。表示范围为 `[-838:59:59, 838:59:59]`。
+ 当前 Doris 中，TIME 作为计算结果的正确性是有保证的（如 `timediff` 等函数），但**不推荐手动 CAST 产生 TIME
类型**。
+ TIME 类型不会在常量折叠中进行计算。
+
+### example
+
+```sql
+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
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
index 9dd6f7d3046..65b696db3ad 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,8 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### 描述
+日期类型包括 DATE、TIME 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。TIME
类型只存储时间，且**暂时不支持建表存储，只能在查询过程中使用**。
-日期类型包括 DATE 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。
+对日期类型进行计算，或将其转换为数字，请使用类似
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp)
等函数，直接将其 CAST 为数字类型的结果不受保证。在未来的版本中，此类 CAST 行为将会被禁止。
-更多信息参考 [DATE](../datetime/DATE.md)、[DATETIME](../datetime/DATETIME.md) 文档。
\ No newline at end of file
+更多信息参考 [DATE](./DATE)、[TIME](./TIME) 和 [DATETIME](./DATETIME) 文档。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
index b79b042e271..b3da85fd423 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
@@ -35,7 +35,8 @@ DATE
日期类型，目前的取值范围是['0000-01-01', '9999-12-31'], 默认的打印形式是'yyyy-MM-dd'
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
index 244c484a837..fb0a0c09bfe 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -37,7 +37,7 @@ DATETIME([P])
### note
-DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用 Stream load、Spark load
等），或开启[新优化器](/docs/query/nereids/nereids-new)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
将带有小数秒部分的 DATETIME 值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
@@ -45,7 +45,7 @@ DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧
<date> <time>[<timezone>]
```
-关于`<timezone>`的具体支持格式，请见[时区](../../../advanced/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
+关于`<timezone>`的具体支持格式，请见[时区](../../../admin-manual/cluster-management/time-zone)。需要注意的是，`DATE`,
`DATEV2`, `DATETIME`, `DATETIMEV2` 类型均**不**包含时区信息。例如，一个输入的时间字符串 "2012-12-12
08:00:00+08:00" 经解析并转换至当前时区 "+02:00"，得到实际值 "2012-12-12 02:00:00" 后存储于 DATETIME
列中，则之后无论本集群环境变量如何改变，该值本身都不会发生变化。
### example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/TIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..bc33374035d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## TIME
+
+### name
+
+TIME
+
+### description
+
+TIME 类型
+ 时间类型，可以作为查询结果出现，暂时不支持建表存储。表示范围为 `[-838:59:59, 838:59:59]`。
+ 当前 Doris 中，TIME 作为计算结果的正确性是有保证的（如 `timediff` 等函数），但**不推荐手动 CAST 产生 TIME
类型**。
+ TIME 类型不会在常量折叠中进行计算。
+
+### example
+
+```sql
+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
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
index 9dd6f7d3046..65b696db3ad 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,8 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### 描述
+日期类型包括 DATE、TIME 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。TIME
类型只存储时间，且**暂时不支持建表存储，只能在查询过程中使用**。
-日期类型包括 DATE 和 DATETIME，DATE 类型只存储日期精确到天，DATETIME 类型存储日期和时间，可以精确到微秒。
+对日期类型进行计算，或将其转换为数字，请使用类似
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp)
等函数，直接将其 CAST 为数字类型的结果不受保证。在未来的版本中，此类 CAST 行为将会被禁止。
-更多信息参考 [DATE](../datetime/DATE.md)、[DATETIME](../datetime/DATETIME.md) 文档。
\ No newline at end of file
+更多信息参考 [DATE](./DATE)、[TIME](./TIME) 和 [DATETIME](./DATETIME) 文档。
\ No newline at end of file
diff --git a/sidebars.json b/sidebars.json
index 4cfd2600242..1f4128c6dab 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -1242,6 +1242,7 @@
"items": [
"sql-manual/sql-data-types/date-time/datetime-overview",
"sql-manual/sql-data-types/date-time/DATE",
+ "sql-manual/sql-data-types/date-time/TIME",
"sql-manual/sql-data-types/date-time/DATETIME"
]
},
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATE.md
b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATE.md
index 83869ef94fa..9788816a2f8 100644
--- a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATE.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATE.md
@@ -40,10 +40,11 @@ If you use version 1.2 and above, it is strongly
recommended that you use the DA
We intend to delete this type in 2024. At this stage, Doris prohibits creating
tables containing the `DATE` type by default. If you need to use it, you need
to add `disable_datev1 = false` in the FE's config and restart the FE.
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
-| date('2003-12-31 01:02:03') |
+| DATE('2003-12-31 01:02:03') |
+-----------------------------+
| 2003-12-31 |
+-----------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/TIME.md
similarity index 55%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
copy to versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/TIME.md
index b79b042e271..13cebe11920 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/TIME.md
@@ -1,7 +1,7 @@
---
{
- "title": "DATE",
- "language": "zh-CN"
+ "title": "TIME",
+ "language": "en"
}
---
@@ -24,26 +24,30 @@ specific language governing permissions and limitations
under the License.
-->
-## DATE
+## TIME
### name
-DATE
+TIME
### description
- DATE类型
- 日期类型，目前的取值范围是['0000-01-01', '9999-12-31'], 默认的打印形式是'yyyy-MM-dd'
+
+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
-```
-SELECT DATE('2003-12-31 01:02:03');
-+-----------------------------+
-| DATE('2003-12-31 01:02:03') |
-+-----------------------------+
-| 2003-12-31 |
-+-----------------------------+
+
+```sql
+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
- DATE
+ TIME
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
index 3a7be464b5f..40017e4a115 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATE.md
@@ -34,7 +34,8 @@ date
Date type, the current range of values is ['0000-01-01','9999-12-31'], and the
default print form is 'yyyy-MM-dd'.
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
index 37808f036ff..5d076b7946c 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -38,14 +38,14 @@ The form of printing is 'yyyy-MM-dd HH:mm:ss.SSSSSS'
### note
-DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the
[Nereids](../../../query-acceleration/nereids) on, decimals exceeding the
current precision will be **rounded**.
+DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the [Nereids](/docs/query/nereids/nereids-new)
on, decimals exceeding the current precision will be **rounded**.
Inserting a DATETIME value with a fractional seconds part into a column of the
same type but having fewer fractional digits results in **rounded**.
DATETIME reads support resolving the time zone in the format of the original
DATETIME literal followed by the time zone:
```sql
<date> <time>[<timezone>]
```
-For the specific supported formats for `<timezone>`, see
[timezone](../../../advanced/time-zone). Note that the `DATE`, `DATEV2`,
`DATETIME`, and `DATETIMEV2` types **don't** contain time zone information. For
example, if an input time string "2012-12-12 08:00:00+08:00" is parsed and
converted to the current time zone "+02:00", and the actual value "2012-12-12
02:00:00" is stored in the DATETIME column, the value itself will not change,
no matter how much the cluster environment variable [...]
+For the specific supported formats for `<timezone>`, see
[timezone](../../../admin-manual/cluster-management/time-zone). Note that the
`DATE`, `DATEV2`, `DATETIME`, and `DATETIMEV2` types **don't** contain time
zone information. For example, if an input time string "2012-12-12
08:00:00+08:00" is parsed and converted to the current time zone "+02:00", and
the actual value "2012-12-12 02:00:00" is stored in the DATETIME column, the
value itself will not change, no matter how much the clust [...]
### example
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/TIME.md
b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..2fcb056d3b3
--- /dev/null
+++ b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 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
+
+```sql
+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
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
index 826a714b887..20d2f9f4e51 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,11 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### Description
+Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp) . The
result of directly converting them as numeric types as not guaranteed.
-The date data types include DATE and DATETIME:
-
-- **[DATE](../datetime/DATE.md)**: It stores only the date. The minimum
precision unit is days.
-
-- **[DATETIME](../datetime/DATETIME.md)**: It stores both the date and time.
The minimum precision unit is milliseconds.
\ No newline at end of file
+For more information refer to [DATE](./DATE), [TIME](./TIME) and
[DATETIME](./DATETIME) documents.
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
index 3a7be464b5f..40017e4a115 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATE.md
@@ -34,7 +34,8 @@ date
Date type, the current range of values is ['0000-01-01','9999-12-31'], and the
default print form is 'yyyy-MM-dd'.
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
index 37808f036ff..5d076b7946c 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -38,14 +38,14 @@ The form of printing is 'yyyy-MM-dd HH:mm:ss.SSSSSS'
### note
-DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the
[Nereids](../../../query-acceleration/nereids) on, decimals exceeding the
current precision will be **rounded**.
+DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the [Nereids](/docs/query/nereids/nereids-new)
on, decimals exceeding the current precision will be **rounded**.
Inserting a DATETIME value with a fractional seconds part into a column of the
same type but having fewer fractional digits results in **rounded**.
DATETIME reads support resolving the time zone in the format of the original
DATETIME literal followed by the time zone:
```sql
<date> <time>[<timezone>]
```
-For the specific supported formats for `<timezone>`, see
[timezone](../../../advanced/time-zone). Note that the `DATE`, `DATEV2`,
`DATETIME`, and `DATETIMEV2` types **don't** contain time zone information. For
example, if an input time string "2012-12-12 08:00:00+08:00" is parsed and
converted to the current time zone "+02:00", and the actual value "2012-12-12
02:00:00" is stored in the DATETIME column, the value itself will not change,
no matter how much the cluster environment variable [...]
+For the specific supported formats for `<timezone>`, see
[timezone](../../../admin-manual/cluster-management/time-zone). Note that the
`DATE`, `DATEV2`, `DATETIME`, and `DATETIMEV2` types **don't** contain time
zone information. For example, if an input time string "2012-12-12
08:00:00+08:00" is parsed and converted to the current time zone "+02:00", and
the actual value "2012-12-12 02:00:00" is stored in the DATETIME column, the
value itself will not change, no matter how much the clust [...]
### example
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/TIME.md
b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..2fcb056d3b3
--- /dev/null
+++ b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 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
+
+```sql
+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
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
index 826a714b887..20d2f9f4e51 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,11 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### Description
+Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp) . The
result of directly converting them as numeric types as not guaranteed.
-The date data types include DATE and DATETIME:
-
-- **[DATE](../datetime/DATE.md)**: It stores only the date. The minimum
precision unit is days.
-
-- **[DATETIME](../datetime/DATETIME.md)**: It stores both the date and time.
The minimum precision unit is milliseconds.
\ No newline at end of file
+For more information refer to [DATE](./DATE), [TIME](./TIME) and
[DATETIME](./DATETIME) documents.
\ No newline at end of file
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
index 3a7be464b5f..40017e4a115 100644
--- a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
+++ b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATE.md
@@ -34,7 +34,8 @@ date
Date type, the current range of values is ['0000-01-01','9999-12-31'], and the
default print form is 'yyyy-MM-dd'.
### example
-```
+
+```sql
SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
index 37808f036ff..5d076b7946c 100644
--- a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
+++ b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/DATETIME.md
@@ -38,14 +38,14 @@ The form of printing is 'yyyy-MM-dd HH:mm:ss.SSSSSS'
### note
-DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the
[Nereids](../../../query-acceleration/nereids) on, decimals exceeding the
current precision will be **rounded**.
+DATETIME supports temporal precision up to microseconds. When parsing imported
DATETIME type data using the BE side (e.g. using Stream load, Spark load,
etc.), or using the FE side with the [Nereids](/docs/query/nereids/nereids-new)
on, decimals exceeding the current precision will be **rounded**.
Inserting a DATETIME value with a fractional seconds part into a column of the
same type but having fewer fractional digits results in **rounded**.
DATETIME reads support resolving the time zone in the format of the original
DATETIME literal followed by the time zone:
```sql
<date> <time>[<timezone>]
```
-For the specific supported formats for `<timezone>`, see
[timezone](../../../advanced/time-zone). Note that the `DATE`, `DATEV2`,
`DATETIME`, and `DATETIMEV2` types **don't** contain time zone information. For
example, if an input time string "2012-12-12 08:00:00+08:00" is parsed and
converted to the current time zone "+02:00", and the actual value "2012-12-12
02:00:00" is stored in the DATETIME column, the value itself will not change,
no matter how much the cluster environment variable [...]
+For the specific supported formats for `<timezone>`, see
[timezone](../../../admin-manual/cluster-management/time-zone). Note that the
`DATE`, `DATEV2`, `DATETIME`, and `DATETIMEV2` types **don't** contain time
zone information. For example, if an input time string "2012-12-12
08:00:00+08:00" is parsed and converted to the current time zone "+02:00", and
the actual value "2012-12-12 02:00:00" is stored in the DATETIME column, the
value itself will not change, no matter how much the clust [...]
### example
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/TIME.md
b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/TIME.md
new file mode 100644
index 00000000000..2fcb056d3b3
--- /dev/null
+++ b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/TIME.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "TIME",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 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
+
+```sql
+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
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
index 826a714b887..20d2f9f4e51 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-data-types/date-time/datetime-overview.md
@@ -24,11 +24,10 @@ specific language governing permissions and limitations
under the License.
-->
+### Description
+Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/date-time-functions/unix-timestamp) . The
result of directly converting them as numeric types as not guaranteed.
-The date data types include DATE and DATETIME:
-
-- **[DATE](../datetime/DATE.md)**: It stores only the date. The minimum
precision unit is days.
-
-- **[DATETIME](../datetime/DATETIME.md)**: It stores both the date and time.
The minimum precision unit is milliseconds.
\ No newline at end of file
+For more information refer to [DATE](./DATE), [TIME](./TIME) and
[DATETIME](./DATETIME) documents.
\ No newline at end of file
diff --git a/versioned_sidebars/version-1.2-sidebars.json
b/versioned_sidebars/version-1.2-sidebars.json
index 0ddca8adbb2..ac1cc72b81b 100644
--- a/versioned_sidebars/version-1.2-sidebars.json
+++ b/versioned_sidebars/version-1.2-sidebars.json
@@ -969,6 +969,7 @@
"sql-manual/sql-reference/Data-Types/DECIMAL",
"sql-manual/sql-reference/Data-Types/DECIMALV3",
"sql-manual/sql-reference/Data-Types/DATE",
+ "sql-manual/sql-reference/Data-Types/TIME",
"sql-manual/sql-reference/Data-Types/DATETIME",
"sql-manual/sql-reference/Data-Types/DATEV2",
"sql-manual/sql-reference/Data-Types/DATETIMEV2",
diff --git a/versioned_sidebars/version-2.0-sidebars.json
b/versioned_sidebars/version-2.0-sidebars.json
index b8e938502cc..04ad97d1094 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -1041,6 +1041,7 @@
"items": [
"sql-manual/sql-data-types/date-time/datetime-overview",
"sql-manual/sql-data-types/date-time/DATE",
+ "sql-manual/sql-data-types/date-time/TIME",
"sql-manual/sql-data-types/date-time/DATETIME"
]
},
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index 1f6b002f5b1..0c9bd387e84 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -1158,6 +1158,7 @@
"items": [
"sql-manual/sql-data-types/date-time/datetime-overview",
"sql-manual/sql-data-types/date-time/DATE",
+ "sql-manual/sql-data-types/date-time/TIME",
"sql-manual/sql-data-types/date-time/DATETIME"
]
},
diff --git a/versioned_sidebars/version-3.0-sidebars.json
b/versioned_sidebars/version-3.0-sidebars.json
index c789c1fc573..c04253915e1 100644
--- a/versioned_sidebars/version-3.0-sidebars.json
+++ b/versioned_sidebars/version-3.0-sidebars.json
@@ -1213,6 +1213,7 @@
"items": [
"sql-manual/sql-data-types/date-time/datetime-overview",
"sql-manual/sql-data-types/date-time/DATE",
+ "sql-manual/sql-data-types/date-time/TIME",
"sql-manual/sql-data-types/date-time/DATETIME"
]
},
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
