This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 3d7a2277bcf [doc](cast) add description of "cast as datetime round "
(#714)
3d7a2277bcf is described below
commit 3d7a2277bcf3294e0304f041b1927f63f430bb02
Author: Mryange <59914473+mrya...@users.noreply.github.com>
AuthorDate: Sat Jun 15 10:59:02 2024 +0800
[doc](cast) add description of "cast as datetime round " (#714)
---
docs/sql-manual/sql-functions/cast.md | 16 +++++++++++++++-
docs/sql-manual/sql-types/Data-Types/DATETIME.md | 1 +
.../current/sql-manual/sql-functions/cast.md | 16 +++++++++++++++-
.../current/sql-manual/sql-types/Data-Types/DATETIME.md | 1 +
.../version-2.0/sql-manual/sql-functions/cast.md | 16 +++++++++++++++-
.../sql-manual/sql-reference/Data-Types/DATETIME.md | 1 +
.../version-2.1/sql-manual/sql-functions/cast.md | 16 +++++++++++++++-
.../sql-manual/sql-types/Data-Types/DATETIME.md | 2 ++
.../version-2.0/sql-manual/sql-functions/cast.md | 16 +++++++++++++++-
.../sql-manual/sql-reference/Data-Types/DATETIME.md | 1 +
.../version-2.1/sql-manual/sql-functions/cast.md | 16 +++++++++++++++-
.../sql-manual/sql-types/Data-Types/DATETIME.md | 1 +
12 files changed, 97 insertions(+), 6 deletions(-)
diff --git a/docs/sql-manual/sql-functions/cast.md
b/docs/sql-manual/sql-functions/cast.md
index dbd5d8d6b09..ab8547b7794 100644
--- a/docs/sql-manual/sql-functions/cast.md
+++ b/docs/sql-manual/sql-functions/cast.md
@@ -74,13 +74,27 @@ mysql> select cast(cast ("11.2" as double) as bigint);
+----------------------------------------+
1 row in set (0.00 sec)
-# For the DECIMALV3 type, the cast operation performs rounding half up.
+# For the DECIMALV3 DATETIME type, the cast operation performs rounding half
up.
mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
| cast(1.115 as DECIMALV3(16, 2)) |
+---------------------------------+
| 1.12 |
+---------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123500' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123500' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.124 |
++-----------------------------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123499' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123499' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.123 |
++-----------------------------------------------------+
```
### Keywords
diff --git a/docs/sql-manual/sql-types/Data-Types/DATETIME.md
b/docs/sql-manual/sql-types/Data-Types/DATETIME.md
index 609ca416f1d..e7ef9672ff1 100644
--- a/docs/sql-manual/sql-types/Data-Types/DATETIME.md
+++ b/docs/sql-manual/sql-types/Data-Types/DATETIME.md
@@ -43,6 +43,7 @@ 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**.
+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>]
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/cast.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/cast.md
index d6e340e254b..24c626d7057 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/cast.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/cast.md
@@ -67,7 +67,7 @@ mysql> select cast(cast ("11.2" as double) as bigint);
1 row in set (0.00 sec)
```
-对于DECIMALV3类型，cast会进行四舍五入
+对于DECIMALV3，DATETIME类型，cast会进行四舍五入
```
mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
@@ -75,6 +75,20 @@ mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
| 1.12 |
+---------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123500' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123500' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.124 |
++-----------------------------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123499' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123499' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.123 |
++-----------------------------------------------------+
```
### keywords
CAST
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-types/Data-Types/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-types/Data-Types/DATETIME.md
index 8b5565fe4ab..47178cbbc0a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-types/Data-Types/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-types/Data-Types/DATETIME.md
@@ -42,6 +42,7 @@ DATETIME([P])
### note
DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用Stream load、Spark
load等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+将带有小数秒部分的DATETIME值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/cast.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/cast.md
index d6e340e254b..24c626d7057 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/cast.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/cast.md
@@ -67,7 +67,7 @@ mysql> select cast(cast ("11.2" as double) as bigint);
1 row in set (0.00 sec)
```
-对于DECIMALV3类型，cast会进行四舍五入
+对于DECIMALV3，DATETIME类型，cast会进行四舍五入
```
mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
@@ -75,6 +75,20 @@ mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
| 1.12 |
+---------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123500' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123500' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.124 |
++-----------------------------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123499' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123499' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.123 |
++-----------------------------------------------------+
```
### keywords
CAST
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
index d819db31baa..38d2d94bf2e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
@@ -42,6 +42,7 @@ DATETIMEV2
### note
DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用Stream load、Spark
load等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+ 将带有小数秒部分的DATETIME值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/cast.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/cast.md
index d6e340e254b..24c626d7057 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/cast.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/cast.md
@@ -67,7 +67,7 @@ mysql> select cast(cast ("11.2" as double) as bigint);
1 row in set (0.00 sec)
```
-对于DECIMALV3类型，cast会进行四舍五入
+对于DECIMALV3，DATETIME类型，cast会进行四舍五入
```
mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
@@ -75,6 +75,20 @@ mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
| 1.12 |
+---------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123500' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123500' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.124 |
++-----------------------------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123499' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123499' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.123 |
++-----------------------------------------------------+
```
### keywords
CAST
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
index 8b5565fe4ab..25cf17bff1a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
@@ -42,6 +42,8 @@ DATETIME([P])
### note
DATETIME 支持了最多到微秒的时间精度。在使用 BE 端解析导入的 DATETIME 类型数据时（如使用Stream load、Spark
load等），或开启[新优化器](../../../query-acceleration/nereids)后在 FE 端解析 DATETIME
类型数据时，将会对超出当前精度的小数进行**四舍五入**。
+将带有小数秒部分的DATETIME值插入到具有较少小数位的相同类型的列中会导致**四舍五入**。
+
DATETIME 读入时支持解析时区，格式为原本 DATETIME 字面量后紧贴时区：
```sql
diff --git a/versioned_docs/version-2.0/sql-manual/sql-functions/cast.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/cast.md
index d4b8484f126..64a2b976aa5 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-functions/cast.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-functions/cast.md
@@ -67,13 +67,27 @@ mysql> select cast(cast ("11.2" as double) as bigint);
+----------------------------------------+
1 row in set (0.00 sec)
-For the DECIMALV3 type, the cast operation performs rounding half up.
+For the DECIMALV3 ,DATETIME type, the cast operation performs rounding half up.
mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
| cast(1.115 as DECIMALV3(16, 2)) |
+---------------------------------+
| 1.12 |
+---------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123500' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123500' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.124 |
++-----------------------------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123499' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123499' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.123 |
++-----------------------------------------------------+
```
### keywords
CAST
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
index 554c9e634a0..32526848169 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Types/DATETIME.md
@@ -42,6 +42,7 @@ 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**.
+ 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>]
diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/cast.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/cast.md
index dbd5d8d6b09..815196ff957 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-functions/cast.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-functions/cast.md
@@ -74,13 +74,27 @@ mysql> select cast(cast ("11.2" as double) as bigint);
+----------------------------------------+
1 row in set (0.00 sec)
-# For the DECIMALV3 type, the cast operation performs rounding half up.
+# For the DECIMALV3 ,DATETIME type, the cast operation performs rounding half
up.
mysql> select cast (1.115 as DECIMALV3(16, 2));
+---------------------------------+
| cast(1.115 as DECIMALV3(16, 2)) |
+---------------------------------+
| 1.12 |
+---------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123500' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123500' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.124 |
++-----------------------------------------------------+
+
+mysql> select cast('2024-12-29-20:40:50.123499' as datetime(3));
++-----------------------------------------------------+
+| cast('2024-12-29-20:40:50.123499' as DATETIMEV2(3)) |
++-----------------------------------------------------+
+| 2024-12-29 20:40:50.123 |
++-----------------------------------------------------+
```
### Keywords
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
b/versioned_docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
index 609ca416f1d..e7ef9672ff1 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-types/Data-Types/DATETIME.md
@@ -43,6 +43,7 @@ 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**.
+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>]
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
