This is an automated email from the ASF dual-hosted git repository.
kassiez 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 77b7f085186 [Doc](date_type) fix date/datetime date_type size not
correct (#2444)
77b7f085186 is described below
commit 77b7f0851867613a38c78b326425333225ffa8d6
Author: HappenLee <[email protected]>
AuthorDate: Fri Jun 6 11:16:00 2025 +0800
[Doc](date_type) fix date/datetime date_type size not correct (#2444)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/table-design/data-type.md | 4 ++--
.../docusaurus-plugin-content-docs/current/table-design/data-type.md | 4 ++--
.../version-2.1/table-design/data-type.md | 4 ++--
.../version-3.0/table-design/data-type.md | 4 ++--
versioned_docs/version-2.1/table-design/data-type.md | 4 ++--
versioned_docs/version-3.0/table-design/data-type.md | 4 ++--
6 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/docs/table-design/data-type.md b/docs/table-design/data-type.md
index 7475a1d095f..830cc956f4a 100644
--- a/docs/table-design/data-type.md
+++ b/docs/table-design/data-type.md
@@ -46,8 +46,8 @@ The list of data types supported by Doris is as follows:
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
-| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 16 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
-| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 16 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
+| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 4 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
+| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 8 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
## [String data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#string-types)
| Type name | Storeage (bytes)| Description
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
index 404f20ff79f..eb4dd212f39 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
@@ -45,8 +45,8 @@ Apache Doris 已支持的数据类型列表如下：
| 类型名 | 存储空间（字节） | 描述
|
| --------------------- | ---------------- |
------------------------------------------------------------------------------------------
|
-| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
16 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
-| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
+| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
4 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
+| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
8 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
###
[字符串类型](../sql-manual/basic-element/sql-data-types/data-type-overview#字符串类型)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
index 404f20ff79f..eb4dd212f39 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
@@ -45,8 +45,8 @@ Apache Doris 已支持的数据类型列表如下：
| 类型名 | 存储空间（字节） | 描述
|
| --------------------- | ---------------- |
------------------------------------------------------------------------------------------
|
-| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
16 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
-| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
+| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
4 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
+| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
8 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
###
[字符串类型](../sql-manual/basic-element/sql-data-types/data-type-overview#字符串类型)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
index 404f20ff79f..eb4dd212f39 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
@@ -45,8 +45,8 @@ Apache Doris 已支持的数据类型列表如下：
| 类型名 | 存储空间（字节） | 描述
|
| --------------------- | ---------------- |
------------------------------------------------------------------------------------------
|
-| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
16 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
-| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
+| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
4 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
+| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
8 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
###
[字符串类型](../sql-manual/basic-element/sql-data-types/data-type-overview#字符串类型)
diff --git a/versioned_docs/version-2.1/table-design/data-type.md
b/versioned_docs/version-2.1/table-design/data-type.md
index f33e981d990..8ba8a5b7fcb 100644
--- a/versioned_docs/version-2.1/table-design/data-type.md
+++ b/versioned_docs/version-2.1/table-design/data-type.md
@@ -46,8 +46,8 @@ The list of data types supported by Doris is as follows:
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
-| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 16 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
-| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 16 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
+| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 4 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
+| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 8 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
## [String data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#string-types)
| Type name | Storeage (bytes)| Description
|
diff --git a/versioned_docs/version-3.0/table-design/data-type.md
b/versioned_docs/version-3.0/table-design/data-type.md
index f33e981d990..8ba8a5b7fcb 100644
--- a/versioned_docs/version-3.0/table-design/data-type.md
+++ b/versioned_docs/version-3.0/table-design/data-type.md
@@ -46,8 +46,8 @@ The list of data types supported by Doris is as follows:
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
-| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 16 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
-| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 16 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
+| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 4 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
+| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 8 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
## [String data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#string-types)
| Type name | Storeage (bytes)| Description
|
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
