This is an automated email from the ASF dual-hosted git repository.
panxiaolei 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 ee12f236274 [Fix](doc) Fix wrong description of behavior of
str_to_date (#1315)
ee12f236274 is described below
commit ee12f236274cdcca2be5df3999b51cb69610147f
Author: zclllhhjj <zhaochan...@selectdb.com>
AuthorDate: Wed Nov 13 19:37:14 2024 +0800
[Fix](doc) Fix wrong description of behavior of str_to_date (#1315)
# Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../sql-functions/date-time-functions/str-to-date.md | 9 ++++-----
.../sql-functions/date-time-functions/str-to-date.md | 10 +++++-----
.../sql-functions/date-time-functions/str-to-date.md | 10 +++++-----
.../sql-functions/date-time-functions/str-to-date.md | 10 +++++-----
.../sql-functions/date-time-functions/str-to-date.md | 10 +++++-----
.../sql-functions/date-time-functions/str-to-date.md | 7 +++----
.../sql-functions/date-time-functions/str-to-date.md | 7 +++----
.../sql-functions/date-time-functions/str-to-date.md | 7 +++----
8 files changed, 33 insertions(+), 37 deletions(-)
diff --git a/docs/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/docs/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 4b46dc25543..d869353e62f 100644
--- a/docs/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++ b/docs/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -28,16 +28,15 @@ under the License.
### Description
#### Syntax
-`DATETIME STR TWO DATES (VARCHAR STR, VARCHAR format)`
+`DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)`
-
-Convert STR to DATE type by format specified, if the conversion result does
not return NULL. Note that the 'format' parameter specifies the format of the
first parameter.
+Convert `str` to `DATETIME` in the manner specified by `format`. If `str`
cannot be parsed in the format specified by `format`, the result is unspecified.
All formats in [date_format](./date-format) are supported. In addition,
support auto completing the remainder of date part for '%Y' and '%Y-%m'.
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 3c219a29fa9..7b14d35ba29 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -25,18 +25,18 @@ under the License.
-->
## str_to_date
-### description
+### Description
#### Syntax
`DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)`
-通过format指定的方式将str转化为DATE类型，如果转化结果不对返回NULL。注意format指定的是第一个参数的格式。
+通过 `format` 指定的方式将 `str` 转化为 `DATETIME` 类型，若 `str` 无法按照 `format` 指定格式解析，则结果未指定。
-支持[date_format](./date-format)中的所有 format 格式，此外对于 '%Y' 和 '%Y-%m'，支持补齐日期剩余部分。
+支持[date_format](./date-format)中的所有 `format` 格式，此外对于 '%Y' 和 '%Y-%m'，支持补齐日期剩余部分。
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 56112c49962..cd00a6edbdd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -25,22 +25,22 @@ under the License.
-->
## str_to_date
-### description
+### Description
#### Syntax
`DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)`
-通过format指定的方式将str转化为DATE类型，如果转化结果不对返回NULL。注意format指定的是第一个参数的格式。
+通过 `format` 指定的方式将 `str` 转化为 `DATETIME` 类型，若 `str` 无法按照 `format` 指定格式解析，则结果未指定。
-支持[date_format](./date-format)中的所有 format 格式，
+支持[date_format](./date-format)中的所有 `format` 格式，
> 自 Doris 2.0.5 开始：
>
> 对于 '%Y' 和 '%Y-%m'，支持自动补齐日期剩余部分。
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 3c219a29fa9..7b14d35ba29 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -25,18 +25,18 @@ under the License.
-->
## str_to_date
-### description
+### Description
#### Syntax
`DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)`
-通过format指定的方式将str转化为DATE类型，如果转化结果不对返回NULL。注意format指定的是第一个参数的格式。
+通过 `format` 指定的方式将 `str` 转化为 `DATETIME` 类型，若 `str` 无法按照 `format` 指定格式解析，则结果未指定。
-支持[date_format](./date-format)中的所有 format 格式，此外对于 '%Y' 和 '%Y-%m'，支持补齐日期剩余部分。
+支持[date_format](./date-format)中的所有 `format` 格式，此外对于 '%Y' 和 '%Y-%m'，支持补齐日期剩余部分。
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 3c219a29fa9..7b14d35ba29 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -25,18 +25,18 @@ under the License.
-->
## str_to_date
-### description
+### Description
#### Syntax
`DATETIME STR_TO_DATE(VARCHAR str, VARCHAR format)`
-通过format指定的方式将str转化为DATE类型，如果转化结果不对返回NULL。注意format指定的是第一个参数的格式。
+通过 `format` 指定的方式将 `str` 转化为 `DATETIME` 类型，若 `str` 无法按照 `format` 指定格式解析，则结果未指定。
-支持[date_format](./date-format)中的所有 format 格式，此外对于 '%Y' 和 '%Y-%m'，支持补齐日期剩余部分。
+支持[date_format](./date-format)中的所有 `format` 格式，此外对于 '%Y' 和 '%Y-%m'，支持补齐日期剩余部分。
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 9a10cb8d4c6..2e4bbdce61f 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -30,8 +30,7 @@ under the License.
`DATETIME STR TWO DATES (VARCHAR STR, VARCHAR format)`
-
-Convert STR to DATE type by format specified, if the conversion result does
not return NULL. Note that the 'format' parameter specifies the format of the
first parameter.
+Convert `str` to `DATETIME` in the manner specified by `format`. If `str`
cannot be parsed in the format specified by `format`, the result is unspecified.
All formats in [date_format](./date-format) are supported.
@@ -39,9 +38,9 @@ All formats in [date_format](./date-format) are supported.
>
> Support auto completing the remainder of date part for '%Y' and '%Y-%m'.
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 4b46dc25543..175cf6eec16 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -30,14 +30,13 @@ under the License.
`DATETIME STR TWO DATES (VARCHAR STR, VARCHAR format)`
-
-Convert STR to DATE type by format specified, if the conversion result does
not return NULL. Note that the 'format' parameter specifies the format of the
first parameter.
+Convert `str` to `DATETIME` in the manner specified by `format`. If `str`
cannot be parsed in the format specified by `format`, the result is unspecified.
All formats in [date_format](./date-format) are supported. In addition,
support auto completing the remainder of date part for '%Y' and '%Y-%m'.
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
index 4b46dc25543..175cf6eec16 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/date-time-functions/str-to-date.md
@@ -30,14 +30,13 @@ under the License.
`DATETIME STR TWO DATES (VARCHAR STR, VARCHAR format)`
-
-Convert STR to DATE type by format specified, if the conversion result does
not return NULL. Note that the 'format' parameter specifies the format of the
first parameter.
+Convert `str` to `DATETIME` in the manner specified by `format`. If `str`
cannot be parsed in the format specified by `format`, the result is unspecified.
All formats in [date_format](./date-format) are supported. In addition,
support auto completing the remainder of date part for '%Y' and '%Y-%m'.
-### example
+### Example
-```
+```sql
mysql> select str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s');
+---------------------------------------------------------+
| str_to_date('2014-12-21 12:34:56', '%Y-%m-%d %H:%i:%s') |
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
