This is an automated email from the ASF dual-hosted git repository.
yjshen pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/master by this push:
new 2598893 doc: separate and fix link for `extract` and `date_part`
(#2104)
2598893 is described below
commit 2598893ac7737e92b3be7b74f606280b32264e0e
Author: Rich <[email protected]>
AuthorDate: Sun Mar 27 21:24:28 2022 -0400
doc: separate and fix link for `extract` and `date_part` (#2104)
* doc: separate extract and date_part
* doc: fix link of extract and date_part
---
docs/source/user-guide/sql/datafusion-functions.md | 20 +++++++++++---------
docs/source/user-guide/sql/sql_status.md | 3 ++-
2 files changed, 13 insertions(+), 10 deletions(-)
diff --git a/docs/source/user-guide/sql/datafusion-functions.md
b/docs/source/user-guide/sql/datafusion-functions.md
index 34c7a0c..e37ba11 100644
--- a/docs/source/user-guide/sql/datafusion-functions.md
+++ b/docs/source/user-guide/sql/datafusion-functions.md
@@ -85,20 +85,22 @@ Note that `CAST(.. AS Timestamp)` converts to Timestamps
with Nanosecond resolut
Note that `CAST(.. AS Timestamp)` converts to Timestamps with Nanosecond
resolution; this function is the only way to convert/cast to seconds resolution.
-## `EXTRACT, date_part`
+## `extract`
-`EXTRACT(field FROM source)`
+`extract(field FROM source)`
- The `extract` function retrieves subfields such as year or hour from
date/time values.
`source` must be a value expression of type timestamp, Data32, or Data64.
`field` is an identifier that selects what field to extract from the source
value.
The `extract` function returns values of type u32.
- - `year` :`EXTRACT(year FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
2020`
- - `month`:`EXTRACT(month FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
9`
- - `week` :`EXTRACT(week FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
37`
- - `day`: `EXTRACT(day FROM to_timestamp('2020-09-08T12:00:00+00:00')) -> 8`
- - `hour`: `EXTRACT(hour FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
12`
- - `minute`: `EXTRACT(minute FROM to_timestamp('2020-09-08T12:01:00+00:00'))
-> 1`
- - `second`: `EXTRACT(second FROM to_timestamp('2020-09-08T12:00:03+00:00'))
-> 3`
+ - `year` :`extract(year FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
2020`
+ - `month`:`extract(month FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
9`
+ - `week` :`extract(week FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
37`
+ - `day`: `extract(day FROM to_timestamp('2020-09-08T12:00:00+00:00')) -> 8`
+ - `hour`: `extract(hour FROM to_timestamp('2020-09-08T12:00:00+00:00')) ->
12`
+ - `minute`: `extract(minute FROM to_timestamp('2020-09-08T12:01:00+00:00'))
-> 1`
+ - `second`: `extract(second FROM to_timestamp('2020-09-08T12:00:03+00:00'))
-> 3`
+
+## `date_part`
`date_part('field', source)`
diff --git a/docs/source/user-guide/sql/sql_status.md
b/docs/source/user-guide/sql/sql_status.md
index 4b33690..8b2a329 100644
--- a/docs/source/user-guide/sql/sql_status.md
+++ b/docs/source/user-guide/sql/sql_status.md
@@ -87,7 +87,8 @@
- [x]
[to_timestamp_millis](docs/user-guide/book/sql/datafusion-functions.html#to_timestamp_millis)
- [x]
[to_timestamp_micros](docs/user-guide/book/sql/datafusion-functions.html#to_timestamp_micros)
- [x]
[to_timestamp_seconds](docs/user-guide/book/sql/datafusion-functions.html#to_timestamp_seconds)
- - [x] [extract,
date_part](docs/user-guide/book/sql/datafusion-functions.html#`EXTRACT,
date_part`)
+ - [x] [extract](docs/user-guide/book/sql/datafusion-functions.html#extract)
+ - [x]
[date_part](docs/user-guide/book/sql/datafusion-functions.html#date_part)
- nested functions
- [x] Array of columns
- [x] Schema Queries
