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 6d671386a3f [Fix](function) Fix wrong str_to_date function parameter
details (#2358)
6d671386a3f is described below
commit 6d671386a3fcc94fc7c83ecc3d0c61bd80ee1532
Author: zclllyybb <[email protected]>
AuthorDate: Thu May 8 11:35:29 2025 +0800
[Fix](function) Fix wrong str_to_date function parameter details (#2358)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../scalar-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../sql-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../scalar-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../scalar-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../sql-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../scalar-functions/date-time-functions/str-to-date.md | 10 +++++++++-
.../scalar-functions/date-time-functions/str-to-date.md | 10 +++++++++-
8 files changed, 72 insertions(+), 8 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
index 6d277977138..9d8ae03d898 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
@@ -38,7 +38,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| Parameter | Description
|
|------------------|------------------------------------------------------------------------------------------------------------------|
| `<datetime_str>` | Required. The input datetime string to be converted.
|
-| `<format>` | Required. The format string specifying the datetime
structure, such as %Y-%m-%d %H:%i:%s or yyyy-MM-dd HH:mm:ss. |
+| `<format>` | Required. The specified datetime format string, such as
`%Y-%m-%d %H:%i:%s`, etc. for specific format parameters, see the
[DATE_FORMAT](./date-format#parameters) documentation. |
+
+In addition, the `<format>` supports the following several alternative formats
and interprets them to the regular format:
+
+|Alternative Input|Interpret as|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## Return Value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
index 8b1946431ae..f391cc32fc8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
@@ -39,7 +39,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| 参数 | 说明
|
|------------------|--------------------------------------------------------------|
| `<datetime_str>` | 必填，输入的日期时间字符串，表示要转换的日期或时间。
|
-| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s` 或 `yyy-MM-dd
HH:mm:ss` |
+| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s`
等，具体格式参数详见[DATE_FORMAT](./date-format#参数)文档 |
+
+除此之外，`<format>` 额外支持以下若干代用格式，并按照正规 format 格式解读：
+
+|代用输入|解读为|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## 返回值
- 返回一个 DATETIME 类型值，表示转换后的日期时间。
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 8b1946431ae..f391cc32fc8 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
@@ -39,7 +39,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| 参数 | 说明
|
|------------------|--------------------------------------------------------------|
| `<datetime_str>` | 必填，输入的日期时间字符串，表示要转换的日期或时间。
|
-| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s` 或 `yyy-MM-dd
HH:mm:ss` |
+| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s`
等，具体格式参数详见[DATE_FORMAT](./date-format#参数)文档 |
+
+除此之外，`<format>` 额外支持以下若干代用格式，并按照正规 format 格式解读：
+
+|代用输入|解读为|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## 返回值
- 返回一个 DATETIME 类型值，表示转换后的日期时间。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
index 8b1946431ae..f391cc32fc8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
@@ -39,7 +39,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| 参数 | 说明
|
|------------------|--------------------------------------------------------------|
| `<datetime_str>` | 必填，输入的日期时间字符串，表示要转换的日期或时间。
|
-| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s` 或 `yyy-MM-dd
HH:mm:ss` |
+| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s`
等，具体格式参数详见[DATE_FORMAT](./date-format#参数)文档 |
+
+除此之外，`<format>` 额外支持以下若干代用格式，并按照正规 format 格式解读：
+
+|代用输入|解读为|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## 返回值
- 返回一个 DATETIME 类型值，表示转换后的日期时间。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
index 8b1946431ae..f391cc32fc8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
@@ -39,7 +39,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| 参数 | 说明
|
|------------------|--------------------------------------------------------------|
| `<datetime_str>` | 必填，输入的日期时间字符串，表示要转换的日期或时间。
|
-| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s` 或 `yyy-MM-dd
HH:mm:ss` |
+| `<format>` | 必填，指定的日期时间格式字符串，如 `%Y-%m-%d %H:%i:%s`
等，具体格式参数详见[DATE_FORMAT](./date-format#参数)文档 |
+
+除此之外，`<format>` 额外支持以下若干代用格式，并按照正规 format 格式解读：
+
+|代用输入|解读为|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## 返回值
- 返回一个 DATETIME 类型值，表示转换后的日期时间。
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 6d277977138..9d8ae03d898 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
@@ -38,7 +38,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| Parameter | Description
|
|------------------|------------------------------------------------------------------------------------------------------------------|
| `<datetime_str>` | Required. The input datetime string to be converted.
|
-| `<format>` | Required. The format string specifying the datetime
structure, such as %Y-%m-%d %H:%i:%s or yyyy-MM-dd HH:mm:ss. |
+| `<format>` | Required. The specified datetime format string, such as
`%Y-%m-%d %H:%i:%s`, etc. for specific format parameters, see the
[DATE_FORMAT](./date-format#parameters) documentation. |
+
+In addition, the `<format>` supports the following several alternative formats
and interprets them to the regular format:
+
+|Alternative Input|Interpret as|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## Return Value
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
index 6d277977138..9d8ae03d898 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
@@ -38,7 +38,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| Parameter | Description
|
|------------------|------------------------------------------------------------------------------------------------------------------|
| `<datetime_str>` | Required. The input datetime string to be converted.
|
-| `<format>` | Required. The format string specifying the datetime
structure, such as %Y-%m-%d %H:%i:%s or yyyy-MM-dd HH:mm:ss. |
+| `<format>` | Required. The specified datetime format string, such as
`%Y-%m-%d %H:%i:%s`, etc. for specific format parameters, see the
[DATE_FORMAT](./date-format#parameters) documentation. |
+
+In addition, the `<format>` supports the following several alternative formats
and interprets them to the regular format:
+
+|Alternative Input|Interpret as|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## Return Value
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
index 6d277977138..9d8ae03d898 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date.md
@@ -38,7 +38,15 @@ STR_TO_DATE(<datetime_str>, <format>)
| Parameter | Description
|
|------------------|------------------------------------------------------------------------------------------------------------------|
| `<datetime_str>` | Required. The input datetime string to be converted.
|
-| `<format>` | Required. The format string specifying the datetime
structure, such as %Y-%m-%d %H:%i:%s or yyyy-MM-dd HH:mm:ss. |
+| `<format>` | Required. The specified datetime format string, such as
`%Y-%m-%d %H:%i:%s`, etc. for specific format parameters, see the
[DATE_FORMAT](./date-format#parameters) documentation. |
+
+In addition, the `<format>` supports the following several alternative formats
and interprets them to the regular format:
+
+|Alternative Input|Interpret as|
+|-|-|
+|`yyyyMMdd`|`%Y%m%d`|
+|`yyyy-MM-dd`|`%Y-%m-%d`|
+|`yyyy-MM-dd HH:mm:ss`|`%Y-%m-%d %H:%i:%s`|
## Return Value
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
