Repository navigation
Implement EXTRACT expression with week, month, day, hour #1896
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
❯ select EXTRACT(HOUR FROM CAST('2020-01-01' AS DATE));
+-----------------------------------------------------------+
| datepart(Utf8("HOUR"),CAST(Utf8("2020-01-01") AS Date32)) |
+-----------------------------------------------------------+
| 0 |
+-----------------------------------------------------------+
1 row in set. Query took 0.002 seconds.
❯ select EXTRACT(WEEK FROM CAST('2020-01-01' AS DATE)); 🤔 Invalid statement: sql parser error: Expected date/time field, found: WEEK
Describe the solution you'd like
implement like postgresql :
SELECT EXTRACT(WEEK FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 7
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
pg start with 1
postgres=# select extract('week' from date '2000-01-01');
date_part
-----------
52
(1 row)
postgres=# select extract('week' from date '2000-01-02');
date_part
-----------
52
(1 row)
postgres=# select extract('week' from date '2000-01-03');
date_part
-----------
1
(1 row)
Activity
[-]Implement EXTRACT expression with week[/-][+]Implement EXTRACT expression with week, month, day, hour[/+]