[jira] [Created] (CALCITE-7522) Allow EXTRACT(interval FROM tz) to operate on TIMESTAMP WITH TIME ZONE

["Mihai Budiu (Jira)" <ji...@apache.org>]

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)