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 7dca17ccf1d add date_add minute_second time unit (#3113)
7dca17ccf1d is described below
commit 7dca17ccf1d2c356444aa89a4352b24bd9673bb9
Author: csding <[email protected]>
AuthorDate: Wed Nov 26 16:01:03 2025 +0800
add date_add minute_second time unit (#3113)
## 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 f702f91df5b..f71ff84de87 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 |
+| `<time_unit>` | Enumeration values: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR,
MINUTE, SECOND, DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
## Return Value
@@ -112,6 +112,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1
2' DAY_HOUR);
| 2025-10-24 12:10:10 |
+----------------------------------------------------------+
+-- Add MINUTE_SECOND
+mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND);
++---------------------------------------------------------------+
+| DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND) |
++---------------------------------------------------------------+
+| 2025-10-23 10:11:11 |
++---------------------------------------------------------------+
+
-- 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 02e8ede2ffb..b11cbf9f145 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 |
+| `<time_unit>` | 枚举值：YEAR, QUARTER, MONTH, WEEK,DAY, HOUR, MINUTE, SECOND,
DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
## 返回值
@@ -111,6 +111,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1
2' DAY_HOUR);
| 2025-10-24 12:10:10 |
+----------------------------------------------------------+
+-- 添加 MINUTE_SECOND
+mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND);
++---------------------------------------------------------------+
+| DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND) |
++---------------------------------------------------------------+
+| 2025-10-23 10:11:11 |
++---------------------------------------------------------------+
+
---非法单位
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 02e8ede2ffb..b11cbf9f145 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 |
+| `<time_unit>` | 枚举值：YEAR, QUARTER, MONTH, WEEK,DAY, HOUR, MINUTE, SECOND,
DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
## 返回值
@@ -111,6 +111,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1
2' DAY_HOUR);
| 2025-10-24 12:10:10 |
+----------------------------------------------------------+
+-- 添加 MINUTE_SECOND
+mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND);
++---------------------------------------------------------------+
+| DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND) |
++---------------------------------------------------------------+
+| 2025-10-23 10:11:11 |
++---------------------------------------------------------------+
+
---非法单位
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 f702f91df5b..8b947b48f49 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 |
+| `<time_unit>` | Enumeration values: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR,
MINUTE, SECOND, DAY_SECOND, DAY_HOUR, MINUTE_SECOND |
## Return Value
@@ -112,6 +112,14 @@ mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1
2' DAY_HOUR);
| 2025-10-24 12:10:10 |
+----------------------------------------------------------+
+-- Add MINUTE_SECOND
+mysql> select DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND);
++---------------------------------------------------------------+
+| DATE_ADD('2025-10-23 10:10:10', INTERVAL '1:1' MINUTE_SECOND) |
++---------------------------------------------------------------+
+| 2025-10-23 10:11:11 |
++---------------------------------------------------------------+
+
-- 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]
