You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit eedc787
Browse filesBrowse the repository at this point in the historyBrowse files
unary_scalar_expr!(Now, now,"current time");//TODO this is not a unary expression https://github.com/apache/arrow-datafusion/issues/3069
Copy file name to clipboardExpand all lines: docs/source/user-guide/sql/scalar_functions.md
+3-2Lines changed: 3 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -246,7 +246,7 @@ Note that `CAST(.. AS Timestamp)` converts to Timestamps with Nanosecond resolut
246
246
`extract(field FROM source)`
247
247
248
248
- The `extract` function retrieves subfields such as year or hour from date/time values.
249
-
`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.
249
+
`source` must be a value expression of type timestamp, Date32, or Date64. `field` is an identifier that selects what field to extract from the source value.
250
250
The `extract` function returns values of type u32.
251
251
-`year` :`extract(year FROM to_timestamp('2020-09-08T12:00:00+00:00')) -> 2020`
252
252
-`month`:`extract(month FROM to_timestamp('2020-09-08T12:00:00+00:00')) -> 9`
@@ -273,7 +273,8 @@ Note that `CAST(.. AS Timestamp)` converts to Timestamps with Nanosecond resolut
273
273
274
274
### `now`
275
275
276
-
current time
276
+
Returns current time as `Timestamp(Nanoseconds, UTC)`. Returns same value for the function
277
+
wherever it appears in the statement, using a value chosen at planning time.
0 commit comments