This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 c0bc31e02d6 [doc](function) update extract doc (#2639)
c0bc31e02d6 is described below
commit c0bc31e02d6380af87c6911c17b1dc38b36d6854
Author: Jensen <[email protected]>
AuthorDate: Sun Jul 27 00:16:21 2025 +0800
[doc](function) update extract doc (#2639)
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/date-time-functions/dayofweek.md | 4 ++++
.../scalar-functions/date-time-functions/dayofyear.md | 4 ++++
.../scalar-functions/date-time-functions/extract.md | 18 +++++++++++-------
.../scalar-functions/date-time-functions/dayofweek.md | 4 ++++
.../scalar-functions/date-time-functions/dayofyear.md | 4 ++++
.../scalar-functions/date-time-functions/extract.md | 18 +++++++++++-------
6 files changed, 38 insertions(+), 14 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
index b7fc5e128a0..0ca5a821297 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
@@ -9,6 +9,10 @@
Returns the weekday index of the date, where Sunday is 1, Monday is 2, and
Saturday is 7.
+## Alias
+
+- DOW
+
## Syntax
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
index 7c9db48efa8..a8ce8142cd0 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
@@ -9,6 +9,10 @@
Obtains the corresponding day of the year for the given date.
+## Alias
+
+- DOY
+
## Syntax
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
index 3fd6ed7ce95..783d3e0f866 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
@@ -17,7 +17,7 @@ The `extract` function is used to extract a specified part of
a date or time val
| Parameter | Description |
| -- | -- |
-| `unit` | The unit to extract from the DATETIME. Possible values are year,
month, day, hour, minute, second, or microsecond |
+| `unit` | The unit to extract from the DATETIME. Possible values are year,
month, day, hour, minute, second, microsecond, dayofyear(doy), dayofweek(dow) |
| `datetime` | The argument is a valid date expression |
## Return Value
@@ -33,13 +33,17 @@ extract(day from '2022-09-22 17:01:30') as day,
extract(hour from '2022-09-22 17:01:30') as hour,
extract(minute from '2022-09-22 17:01:30') as minute,
extract(second from '2022-09-22 17:01:30') as second,
-extract(microsecond from cast('2022-09-22 17:01:30.000123' as datetimev2(6)))
as microsecond;
+extract(microsecond from cast('2022-09-22 17:01:30.000123' as datetimev2(6)))
as microsecond,
+extract(dayofyear FROM '2022-09-22 17:01:30') as dayofyear,
+extract(doy FROM '2022-09-22 17:01:30') as dayofyear_alias,
+extract(dayofweek FROM '2022-09-22 17:01:30') as dayofweek,
+extract(dow FROM '2022-09-22 17:01:30') as dayofweek_alias;
```
```text
-+------+-------+------+------+--------+--------+-------------+
-| year | month | day | hour | minute | second | microsecond |
-+------+-------+------+------+--------+--------+-------------+
-| 2022 | 9 | 22 | 17 | 1 | 30 | 123 |
-+------+-------+------+------+--------+--------+-------------+
++------+-------+------+------+--------+--------+-------------+-----------+-----------------+-----------+-----------------+
+| year | month | day | hour | minute | second | microsecond | dayofyear |
dayofyear_alias | dayofweek | dayofweek_alias |
++------+-------+------+------+--------+--------+-------------+-----------+-----------------+-----------+-----------------+
+| 2022 | 9 | 22 | 17 | 1 | 30 | 123 | 265 |
265 | 5 | 5 |
++------+-------+------+------+--------+--------+-------------+-----------+-----------------+-----------+-----------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
index c5a5e4befa4..661651b1e6a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek.md
@@ -9,6 +9,10 @@
返回日期的工作日索引值，即星期日为 1，星期一为 2，星期六为 7。
+## 别名
+
+- DOW
+
## 语法
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
index a346a079e9b..c849515e1ca 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear.md
@@ -9,6 +9,10 @@
获得日期中对应当年中的哪一天。
+## 别名
+
+- DOY
+
## 语法
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
index c45e14f3e24..4869212a05e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
@@ -17,7 +17,7 @@
| 参数 | 说明 |
| -- | -- |
-| `unit` | 提取 DATETIME 某个指定单位的值。单位可以为 year, month, day, hour, minute, second
或者 microsecond |
+| `unit` | 提取 DATETIME 某个指定单位的值。单位可以为 year, month, day, hour, minute, second,
microsecond, dayofyear(doy), dayofweek(dow) |
| `datetime` | 参数是合法的日期表达式 |
## 返回值
@@ -33,13 +33,17 @@ extract(day from '2022-09-22 17:01:30') as day,
extract(hour from '2022-09-22 17:01:30') as hour,
extract(minute from '2022-09-22 17:01:30') as minute,
extract(second from '2022-09-22 17:01:30') as second,
-extract(microsecond from cast('2022-09-22 17:01:30.000123' as datetimev2(6)))
as microsecond;
+extract(microsecond from cast('2022-09-22 17:01:30.000123' as datetimev2(6)))
as microsecond,
+extract(dayofyear FROM '2022-09-22 17:01:30') as dayofyear,
+extract(doy FROM '2022-09-22 17:01:30') as dayofyear_alias,
+extract(dayofweek FROM '2022-09-22 17:01:30') as dayofweek,
+extract(dow FROM '2022-09-22 17:01:30') as dayofweek_alias;
```
```text
-+------+-------+------+------+--------+--------+-------------+
-| year | month | day | hour | minute | second | microsecond |
-+------+-------+------+------+--------+--------+-------------+
-| 2022 | 9 | 22 | 17 | 1 | 30 | 123 |
-+------+-------+------+------+--------+--------+-------------+
++------+-------+------+------+--------+--------+-------------+-----------+-----------------+-----------+-----------------+
+| year | month | day | hour | minute | second | microsecond | dayofyear |
dayofyear_alias | dayofweek | dayofweek_alias |
++------+-------+------+------+--------+--------+-------------+-----------+-----------------+-----------+-----------------+
+| 2022 | 9 | 22 | 17 | 1 | 30 | 123 | 265 |
265 | 5 | 5 |
++------+-------+------+------+--------+--------+-------------+-----------+-----------------+-----------+-----------------+
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
