This is an automated email from the ASF dual-hosted git repository.
zclll 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 2228e7f977e Support backslash for datetime strict-mode parsing in date
part (#2913)
2228e7f977e is described below
commit 2228e7f977ed5e25960167bf09ec99ed7688824e
Author: zclllyybb <[email protected]>
AuthorDate: Thu Sep 25 14:31:19 2025 +0800
Support backslash for datetime strict-mode parsing in date part (#2913)
doc of https://github.com/apache/doris/pull/56437
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../basic-element/sql-data-types/conversion/date-conversion.md | 4 ++--
.../basic-element/sql-data-types/conversion/datetime-conversion.md | 4 ++--
.../basic-element/sql-data-types/conversion/date-conversion.md | 4 ++--
.../basic-element/sql-data-types/conversion/datetime-conversion.md | 4 ++--
4 files changed, 8 insertions(+), 8 deletions(-)
diff --git
a/docs/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
b/docs/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
index 524b13f8fd2..d50e4d06813 100644
--- a/docs/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
+++ b/docs/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
@@ -19,7 +19,7 @@ Valid range for DATE type: `[0000-01-01, 9999-12-31]`
––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––
-<date> ::= <year> "-" <month1> "-" <day1>
+<date> ::= <year> ("-" | "/") <month1> ("-" | "/") <day1>
| <year> <month2> <day2>
<year> ::= <digit>{2} | <digit>{4} ; 1970 as the boundary
@@ -209,7 +209,7 @@ Assume the current Doris time zone is UTC+8 (`+08:00`). For
the effect of time z
| `120102030405.999` | Error (format error) | Missing
DATE - TIME separator |
| `2020-05-05 12:30:60` | `2020-05-05` | Invalid seconds,
but not part of DATE interpretation |
| `2023-07-16T19.123+08:00` | Error (format error) | Date
contains non-contiguous fields (hour + milliseconds skip minute, second)
|
-| `2024/05/01` | Error (format error) | Date
separator uses '/' |
+| `2024/05/01` | `2024-05-01` | Date separator
uses '/' |
| `24012` | Error (format error) | Invalid
date digit count |
| `2411 123` | Error (format error) | Invalid
digit count for both date and time parts |
| `2024-05-01 01:030:02` | Error (format error) | Invalid
minute digit count |
diff --git
a/docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
b/docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
index b9ab09a8293..7c62c004cf8 100644
---
a/docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
+++
b/docs/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
@@ -23,7 +23,7 @@ The DATETIME type includes a type parameter `p`, which
represents the number of
––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––
-<date> ::= <year> "-" <month1> "-" <day1>
+<date> ::= <year> ("-" | "/") <month1> ("-" | "/") <day1>
| <year> <month2> <day2>
<year> ::= <digit>{2} | <digit>{4} ; 1970 as the boundary
@@ -220,7 +220,7 @@ Assume the current Doris time zone is UTC+8 (`+08:00`). For
the effect of time z
| `20120102030405.123 +08` | `2012-01-02 03:05:05.123000` |
14-digit concatenated date format + decimal + short timezone offset
|
| `120102030405.999` | Error (format error)
| Missing DATE - TIME separator |
| `2023-07-16T19.123+08:00` | Error (format error)
| Date has non-consecutive fields (hour+milliseconds skipping minutes and
seconds) |
-| `2024/05/01` | Error (format error)
| Date separator uses '/' |
+| `2024/05/01` | `2024-05-01` |
Date separator uses '/' |
| `24012` | Error (format error)
| Invalid number of digits for date |
| `2411 123` | Error (format error)
| Invalid number of digits for both date and time parts
|
| `2024-05-01 01:030:02` | Error (format error)
| Invalid number of digits for minutes |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
index bbcf16610ba..6b1b0a43665 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/date-conversion.md
@@ -19,7 +19,7 @@ DATE 类型支持的合法时间上下界：`[0000-01-01, 9999-12-31]`
––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––
-<date> ::= <year> "-" <month1> "-" <day1>
+<date> ::= <year> ("-" | "/") <month1> ("-" | "/") <day1>
| <year> <month2> <day2>
<year> ::= <digit>{2} | <digit>{4} ; 1970 为界
@@ -209,7 +209,7 @@ DATE 类型支持的合法时间上下界：`[0000-01-01, 9999-12-31]`
| `120102030405.999` | 报错（格式错误） | 缺少 DATE - TIME 分隔符
|
| `2020-05-05 12:30:60` | `2020-05-05` | 秒不合法，但不属于 DATE
解读的部分 |
| `2023-07-16T19.123+08:00` | 报错（格式错误） |
日期出现非连续域（小时+毫秒跳过了分钟、秒） |
-| `2024/05/01` | 报错（格式错误） | 日期分隔符使用“/”
|
+| `2024/05/01` | `2024-05-01` | 日期分隔符使用“/”
|
| `24012` | 报错（格式错误） | 日期位数不合法
|
| `2411 123` | 报错（格式错误） | 日期和时间部分位数均不合法
|
| `2024-05-01 01:030:02` | 报错（格式错误） | 分钟位数不合法
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
index b7b78fa2f6b..c6393ad7489 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion.md
@@ -23,7 +23,7 @@ DATETIME 类型包含类型参数 `p`，即小数位数。完整表示为 `DATET
––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––
-<date> ::= <year> "-" <month1> "-" <day1>
+<date> ::= <year> ("-" | "/") <month1> ("-" | "/") <day1>
| <year> <month2> <day2>
<year> ::= <digit>{2} | <digit>{4} ; 1970 为界
@@ -221,7 +221,7 @@ DATETIME 类型包含类型参数 `p`，即小数位数。完整表示为 `DATET
| `120102030405.999` | 报错（格式错误） | 缺少
DATE - TIME 分隔符 |
| `2024-05-01 0:1:2.333` | `2024-05-01 00:01:02.333000` | 连写日期 +
“T” + 个位时分秒 + 毫秒 |
| `2023-07-16T19.123+08:00` | 报错（格式错误） |
日期出现非连续域（小时+毫秒跳过了分钟、秒） |
-| `2024/05/01` | 报错（格式错误） |
日期分隔符使用“/” |
+| `2024/05/01` | `2024-05-01` |
日期分隔符使用“/” |
| `24012` | 报错（格式错误） |
日期位数不合法 |
| `2411 123` | 报错（格式错误） |
日期和时间部分位数均不合法 |
| `2024-05-01 01:030:02` | 报错（格式错误） |
分钟位数不合法 |
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
