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 bb9bc8df623 [doc](function) from-days (#750)
bb9bc8df623 is described below
commit bb9bc8df623b54a5ad9a367ea65ce981c2a00acf
Author: Mryange <59914473+mrya...@users.noreply.github.com>
AuthorDate: Mon Jun 17 11:26:38 2024 +0800
[doc](function) from-days (#750)
---
.../sql-functions/date-time-functions/from-days.md | 25 ++++++++++++++++++++--
.../sql-functions/date-time-functions/from-days.md | 23 +++++++++++++++++++-
.../sql-functions/date-time-functions/from_days.md | 23 +++++++++++++++++++-
.../sql-manual/sql-reference/Data-Types/DATEV2.md | 1 +
.../sql-functions/date-time-functions/from-days.md | 24 ++++++++++++++++++++-
.../sql-functions/date-time-functions/from-days.md | 24 ++++++++++++++++++++-
.../sql-functions/date-time-functions/from_days.md | 25 ++++++++++++++++++++--
.../sql-manual/sql-reference/Data-Types/DATEV2.md | 2 +-
.../sql-functions/date-time-functions/from-days.md | 25 ++++++++++++++++++++--
.../sql-functions/date-time-functions/from-days.md | 25 ++++++++++++++++++++--
10 files changed, 184 insertions(+), 13 deletions(-)
diff --git a/docs/sql-manual/sql-functions/date-time-functions/from-days.md
b/docs/sql-manual/sql-functions/date-time-functions/from-days.md
index 343d337a1ab..33ac1db8445 100644
--- a/docs/sql-manual/sql-functions/date-time-functions/from-days.md
+++ b/docs/sql-manual/sql-functions/date-time-functions/from-days.md
@@ -31,17 +31,38 @@ under the License.
`DATE FROM_DAYS(INT N)`
-Calculate which day by the number of days from 0000-01-01
+Given a day number, returns a DATE. Note that to maintain consistent behavior
with MySQL, the date 0000-02-29 does not exist.
### example
```
-mysql > select from u days (730669);
+mysql > select from_days (730669);
+-------------------+
| from_days(730669) |
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/from-days.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/from-days.md
index fb13afadc0f..d27abc36530 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/from-days.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/from-days.md
@@ -31,7 +31,7 @@ under the License.
`DATE FROM_DAYS(INT N)`
-通过距离0000-01-01日的天数计算出哪一天
+给定一个天数，返回一个DATE。注意，为了和mysql保持一致的行为，不存在0000-02-29这个日期。
### example
@@ -42,6 +42,27 @@ mysql> select from_days(730669);
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
index 883a8e9ee51..9b888747b43 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
@@ -31,7 +31,7 @@ under the License.
`DATE FROM_DAYS(INT N)`
-通过距离0000-01-01日的天数计算出哪一天
+给定一个天数，返回一个DATE。注意，为了和mysql保持一致的行为，不存在0000-02-29这个日期。
### example
@@ -42,6 +42,27 @@ mysql> select from_days(730669);
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
index 3126eb416c5..9699bdcb148 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
@@ -40,6 +40,7 @@ DATEV2
### note
DATEV2类型相比DATE类型更加高效，在计算时，DATEV2相比DATE可以节省一半的内存使用量。
+ 为了和mysql保持一致的行为，不存在0000-02-29这个日期。
### example
mysql> SELECT CAST('2003-12-31 01:02:03' as DATEV2);
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
index fb13afadc0f..45632db2f44 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
@@ -31,7 +31,8 @@ under the License.
`DATE FROM_DAYS(INT N)`
-通过距离0000-01-01日的天数计算出哪一天
+给定一个天数，返回一个DATE。注意，为了和mysql保持一致的行为，不存在0000-02-29这个日期。
+
### example
@@ -42,6 +43,27 @@ mysql> select from_days(730669);
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
index fb13afadc0f..45632db2f44 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
@@ -31,7 +31,8 @@ under the License.
`DATE FROM_DAYS(INT N)`
-通过距离0000-01-01日的天数计算出哪一天
+给定一个天数，返回一个DATE。注意，为了和mysql保持一致的行为，不存在0000-02-29这个日期。
+
### example
@@ -42,6 +43,27 @@ mysql> select from_days(730669);
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
index d774a27d736..43be1a884cf 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/date-time-functions/from_days.md
@@ -31,17 +31,38 @@ under the License.
`DATE FROM_DAYS(INT N)`
-Calculate which day by the number of days from 0000-01-01
+Given a day number, returns a DATE. Note that to maintain consistent behavior
with MySQL, the date 0000-02-29 does not exist.
### example
```
-mysql > select from u days (730669);
+mysql> select from_days(730669);
+-------------------+
| from_days(730669) |
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
index 8e686d1c6b1..91e37ea6a6e 100644
--- a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Types/DATEV2.md
@@ -39,7 +39,7 @@ DateV2 type, the current range of values is
['0000-01-01','9999-12-31'], and the
### note
DATEV2 type is more efficient than DATE type. During calculation, DATEV2 can
save half of the memory usage compared with DATE.
-
+Note that to maintain consistent behavior with MySQL, the date 0000-02-29 does
not exist.
### example
```
SELECT CAST('2003-12-31 01:02:03' as DATEV2);
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
index 343d337a1ab..e70e62647c4 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/from-days.md
@@ -31,17 +31,38 @@ under the License.
`DATE FROM_DAYS(INT N)`
-Calculate which day by the number of days from 0000-01-01
+Given a day number, returns a DATE. Note that to maintain consistent behavior
with MySQL, the date 0000-02-29 does not exist.
### example
```
-mysql > select from u days (730669);
+mysql> select from_days(730669);
+-------------------+
| from_days(730669) |
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
index 343d337a1ab..e70e62647c4 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/from-days.md
@@ -31,17 +31,38 @@ under the License.
`DATE FROM_DAYS(INT N)`
-Calculate which day by the number of days from 0000-01-01
+Given a day number, returns a DATE. Note that to maintain consistent behavior
with MySQL, the date 0000-02-29 does not exist.
### example
```
-mysql > select from u days (730669);
+mysql> select from_days(730669);
+-------------------+
| from_days(730669) |
+-------------------+
| 2000-07-03 |
+-------------------+
+
+mysql> select from_days (5);
++--------------+
+| from_days(5) |
++--------------+
+| 0000-01-05 |
++--------------+
+
+mysql> select from_days (59);
++---------------+
+| from_days(59) |
++---------------+
+| 0000-02-28 |
++---------------+
+
+mysql> select from_days (60);
++---------------+
+| from_days(60) |
++---------------+
+| 0000-03-01 |
++---------------+
```
### keywords
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
