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 fdf3be4b0fb [doc](function) add some test cases to second and
microsecond function (#3120)
fdf3be4b0fb is described below
commit fdf3be4b0fb5badb8b7faef1bb01364772ef9530
Author: dwdwqfwe <[email protected]>
AuthorDate: Wed Nov 26 18:04:25 2025 +0800
[doc](function) add some test cases to second and microsecond function
(#3120)
doc of https://github.com/apache/doris/pull/56659
## Versions
- [x] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/date-time-functions/microsecond.md | 8 ++++++++
.../sql-functions/scalar-functions/date-time-functions/second.md | 8 ++++++++
.../scalar-functions/date-time-functions/microsecond.md | 8 ++++++++
.../sql-functions/scalar-functions/date-time-functions/second.md | 8 ++++++++
.../scalar-functions/date-time-functions/microsecond.md | 8 ++++++++
.../sql-functions/scalar-functions/date-time-functions/second.md | 8 ++++++++
.../scalar-functions/date-time-functions/microsecond.md | 8 ++++++++
.../sql-functions/scalar-functions/date-time-functions/second.md | 8 ++++++++
8 files changed, 64 insertions(+)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
index a5cee0aad03..fef1bc2bb49 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
@@ -68,6 +68,14 @@ SELECT MICROSECOND(CAST('1999-01-02 10:11:12' AS
DATETIME(6)));
| 0 |
+---------------------------------------------------------+
+-- When a string literal is valid for both datetime and time, prefer parsing
it as time
+SELECT MICROSECOND("22:12:12.123456");
++--------------------------------+
+| MICROSECOND("22:12:12.123456") |
++--------------------------------+
+| 123456 |
++--------------------------------+
+
-- Input is NULL, returns NULL
SELECT MICROSECOND(NULL);
+-------------------+
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
index cf29c25fab2..bf4ff4c7a2b 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
@@ -75,6 +75,14 @@ SELECT SECOND('2024-01-01 00:00:00') AS result;
| 0 |
+--------+
+-- When a string literal is valid for both datetime and time, prefer parsing
it as time
+SELECT SECOND("22:12:12");
++--------------------+
+| SECOND("22:12:12") |
++--------------------+
+| 12 |
++--------------------+
+
-- Input is NULL (returns NULL)
SELECT SECOND(NULL) AS result;
+--------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
index 929bae687ad..3fe2d3b3b6e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
@@ -67,6 +67,14 @@ SELECT MICROSECOND(CAST('1999-01-02 10:11:12' AS
DATETIME(6)));
| 0 |
+---------------------------------------------------------+
+--- 输入字符串同时适用于 datetime/time 时，优先按 time 解析
+SELECT MICROSECOND("22:12:12.123456");
++--------------------------------+
+| MICROSECOND("22:12:12.123456") |
++--------------------------------+
+| 123456 |
++--------------------------------+
+
---输入 NULL，返回 NULL
SELECT MICROSECOND(NULL);
+-------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
index b008988e775..8fad807d945 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
@@ -72,6 +72,14 @@ SELECT SECOND('2024-01-01 00:00:00') AS result;
| 0 |
+--------+
+-- 输入情况为 datetime/time 类型都适用的字符串，则优先选择 time 类型
+SELECT SECOND("22:12:12");
++--------------------+
+| SECOND("22:12:12") |
++--------------------+
+| 12 |
++--------------------+
+
--- 输入为 NULL（返回 NULL）
SELECT SECOND(NULL) AS result;
+--------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
index 929bae687ad..3fe2d3b3b6e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
@@ -67,6 +67,14 @@ SELECT MICROSECOND(CAST('1999-01-02 10:11:12' AS
DATETIME(6)));
| 0 |
+---------------------------------------------------------+
+--- 输入字符串同时适用于 datetime/time 时，优先按 time 解析
+SELECT MICROSECOND("22:12:12.123456");
++--------------------------------+
+| MICROSECOND("22:12:12.123456") |
++--------------------------------+
+| 123456 |
++--------------------------------+
+
---输入 NULL，返回 NULL
SELECT MICROSECOND(NULL);
+-------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
index b008988e775..8fad807d945 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
@@ -72,6 +72,14 @@ SELECT SECOND('2024-01-01 00:00:00') AS result;
| 0 |
+--------+
+-- 输入情况为 datetime/time 类型都适用的字符串，则优先选择 time 类型
+SELECT SECOND("22:12:12");
++--------------------+
+| SECOND("22:12:12") |
++--------------------+
+| 12 |
++--------------------+
+
--- 输入为 NULL（返回 NULL）
SELECT SECOND(NULL) AS result;
+--------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
index a5cee0aad03..fef1bc2bb49 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond.md
@@ -68,6 +68,14 @@ SELECT MICROSECOND(CAST('1999-01-02 10:11:12' AS
DATETIME(6)));
| 0 |
+---------------------------------------------------------+
+-- When a string literal is valid for both datetime and time, prefer parsing
it as time
+SELECT MICROSECOND("22:12:12.123456");
++--------------------------------+
+| MICROSECOND("22:12:12.123456") |
++--------------------------------+
+| 123456 |
++--------------------------------+
+
-- Input is NULL, returns NULL
SELECT MICROSECOND(NULL);
+-------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
index cf29c25fab2..bf4ff4c7a2b 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/second.md
@@ -75,6 +75,14 @@ SELECT SECOND('2024-01-01 00:00:00') AS result;
| 0 |
+--------+
+-- When a string literal is valid for both datetime and time, prefer parsing
it as time
+SELECT SECOND("22:12:12");
++--------------------+
+| SECOND("22:12:12") |
++--------------------+
+| 12 |
++--------------------+
+
-- Input is NULL (returns NULL)
SELECT SECOND(NULL) AS result;
+--------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
