Mihai Budiu created CALCITE-7522:
------------------------------------
Summary: Allow EXTRACT(interval FROM tz) to operate on TIMESTAMP
WITH TIME ZONE
Key: CALCITE-7522
URL: https://issues.apache.org/jira/browse/CALCITE-7522
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.41.0
Reporter: Mihai Budiu
{code:java}
SELECT EXTRACT(YEAR FROM TIMESTAMP WITH TIME ZONE '2020-01-01 10:10:10
America/New_York'); {code}
today results in a validation error:
{code:java}
Cannot apply 'EXTRACT' to arguments of type 'EXTRACT(<INTERVAL YEAR> FROM
<TIMESTAMP_TZ(0)>)'. Supported form(s): 'EXTRACT(<DATETIME_INTERVAL> FROM
<DATETIME_INTERVAL>)'
'EXTRACT(<DATETIME_INTERVAL> FROM <DATETIME>)'
'EXTRACT(<INTERVAL_DAY_TIME> FROM <INTERVAL_YEAR_MONTH>)' {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
