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 4556d55461d add date_add SECOND_MICROSECOND timeunit (#3151)
4556d55461d is described below
commit 4556d55461d27f631b79643ab3859a4f816e81ae
Author: csding <[email protected]>
AuthorDate: Fri Dec 5 04:08:34 2025 +0800
add date_add SECOND_MICROSECOND timeunit (#3151)
## 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/date-add.md | 10 +++++++++-
.../scalar-functions/date-time-functions/date-add.md | 10 +++++++++-
.../scalar-functions/date-time-functions/date-add.md | 10 +++++++++-
.../scalar-functions/date-time-functions/date-add.md | 10 +++++++++-
4 files changed, 36 insertions(+), 4 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
index f71ff84de87..e212d27d6ef 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
@@ -29,7 +29,7 @@ DATE_ADD(<date_or_time_expr>, <expr> <time_unit>)
| -- | -- |
| `<date_or_time_expr>` | The date/time value to be processed. Supported
types: datetime or date type, with a maximum precision of six decimal places
for seconds (e.g., 2022-12-28 23:59:59.999999). For specific datetime and date
formats, please refer to [datetime
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
and [date
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion)
|
| `<expr>` | The time interval to be added, of `INT` type |
-| `<time_unit>` | Enumeration values: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR,
MINUTE, SECOND, DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
+| `<time_unit>` | Enumeration values: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR,
MINUTE, SECOND, DAY_SECOND, DAY_HOUR, MINUTE_SECOND, SECOND_MICROSECOND |
## Return Value
@@ -120,6 +120,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL
'1:1' MINUTE_SECOND);
| 2025-10-23 10:11:11 |
+---------------------------------------------------------------+
+-- Add SECOND_MICROSECOND
+mysql> select date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1"
SECOND_MICROSECOND);
++---------------------------------------------------------------------------+
+| date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1" SECOND_MICROSECOND) |
++---------------------------------------------------------------------------+
+| 2025-10-10 10:10:11.223456 |
++---------------------------------------------------------------------------+
+
-- Illegal unit
select DATE_ADD('2023-12-31 23:00:00', INTERVAL 2 sa);
ERROR 1105 (HY000): errCode = 2, detailMessage =
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
index b11cbf9f145..1480ce8b2ae 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
@@ -29,7 +29,7 @@ DATE_ADD(<date_or_time_expr>, <expr> <time_unit>)
| -- | -- |
| `<date_or_time_expr>` | 待处理的日期/时间值。支持类型：为 datetime 或者 date 类型，最高有六位秒数的精度（如
2022-12-28 23:59:59.999999），具体 datetime 和 date 格式请查看 [datetime
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
和 [date
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/date-conversion))|
| `<expr>` | 希望添加的时间间隔，为 `INT` 类型|
-| `<time_unit>` | 枚举值：YEAR, QUARTER, MONTH, WEEK,DAY, HOUR, MINUTE, SECOND,
DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
+| `<time_unit>` | 枚举值：YEAR, QUARTER, MONTH, WEEK,DAY, HOUR, MINUTE, SECOND,
DAY_SECOND, DAY_HOUR, MINUTE_SECOND, SECOND_MICROSECOND |
## 返回值
@@ -119,6 +119,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL
'1:1' MINUTE_SECOND);
| 2025-10-23 10:11:11 |
+---------------------------------------------------------------+
+-- 添加 SECOND_MICROSECOND
+mysql> select date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1"
SECOND_MICROSECOND);
++---------------------------------------------------------------------------+
+| date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1" SECOND_MICROSECOND) |
++---------------------------------------------------------------------------+
+| 2025-10-10 10:10:11.223456 |
++---------------------------------------------------------------------------+
+
---非法单位
select DATE_ADD('2023-12-31 23:00:00', INTERVAL 2 sa);
ERROR 1105 (HY000): errCode = 2, detailMessage =
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
index b11cbf9f145..9f93ab454f2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
@@ -29,7 +29,7 @@ DATE_ADD(<date_or_time_expr>, <expr> <time_unit>)
| -- | -- |
| `<date_or_time_expr>` | 待处理的日期/时间值。支持类型：为 datetime 或者 date 类型，最高有六位秒数的精度（如
2022-12-28 23:59:59.999999），具体 datetime 和 date 格式请查看 [datetime
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
和 [date
的转换](../../../../../current/sql-manual/basic-element/sql-data-types/conversion/date-conversion))|
| `<expr>` | 希望添加的时间间隔，为 `INT` 类型|
-| `<time_unit>` | 枚举值：YEAR, QUARTER, MONTH, WEEK,DAY, HOUR, MINUTE, SECOND,
DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
+| `<time_unit>` | 枚举值：YEAR, QUARTER, MONTH, WEEK,DAY, HOUR, MINUTE, SECOND,
DAY_SECOND, DAY_HOUR, MINUTE_SECOND, SECOND_MICROSECOND |
## 返回值
@@ -119,6 +119,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL
'1:1' MINUTE_SECOND);
| 2025-10-23 10:11:11 |
+---------------------------------------------------------------+
+-- 添加 SECOND_MICROSECOND
+mysql> select date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1"
SECOND_MICROSECOND);
++---------------------------------------------------------------------------+
+| date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1" SECOND_MICROSECOND) |
++---------------------------------------------------------------------------+
+| 2025-10-10 10:10:11.223456 |
++---------------------------------------------------------------------------
+
---非法单位
select DATE_ADD('2023-12-31 23:00:00', INTERVAL 2 sa);
ERROR 1105 (HY000): errCode = 2, detailMessage =
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
index 8b947b48f49..a257ea8fe2c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/date-add.md
@@ -29,7 +29,7 @@ DATE_ADD(<date_or_time_expr>, <expr> <time_unit>)
| -- | -- |
| `<date_or_time_expr>` | The date/time value to be processed. Supported
types: datetime or date type, with a maximum precision of six decimal places
for seconds (e.g., 2022-12-28 23:59:59.999999). For specific datetime and date
formats, please refer to [datetime
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/datetime-conversion)
and [date
conversion](../../../../sql-manual/basic-element/sql-data-types/conversion/date-conversion)
|
| `<expr>` | The time interval to be added, of `INT` type |
-| `<time_unit>` | Enumeration values: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR,
MINUTE, SECOND, DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
+| `<time_unit>` | Enumeration values: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR,
MINUTE, SECOND, DAY_SECOND, DAY_HOUR, MINUTE_SECOND, SECOND_MICROSECOND |
## Return Value
@@ -120,6 +120,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL
'1:1' MINUTE_SECOND);
| 2025-10-23 10:11:11 |
+---------------------------------------------------------------+
+-- Add SECOND_MICROSECOND
+mysql> select date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1"
SECOND_MICROSECOND);
++---------------------------------------------------------------------------+
+| date_add("2025-10-10 10:10:10.123456", INTERVAL "1.1" SECOND_MICROSECOND) |
++---------------------------------------------------------------------------+
+| 2025-10-10 10:10:11.223456 |
++---------------------------------------------------------------------------+
+
-- Illegal unit
select DATE_ADD('2023-12-31 23:00:00', INTERVAL 2 sa);
ERROR 1105 (HY000): errCode = 2, detailMessage =
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
