[jira] [Created] (CALCITE-7021) Support parse 'CAST('1' AS INTERVAL)'

[xiong duan (Jira)]

xiong duan created CALCITE-7021:
-----------------------------------

             Summary: Support parse 'CAST('1' AS INTERVAL)' 
                 Key: CALCITE-7021
                 URL: https://issues.apache.org/jira/browse/CALCITE-7021
             Project: Calcite
          Issue Type: Bug
            Reporter: xiong duan


Now we have supported :
{code:java}
CAST(VALUE as INTERVAL YEAY)、CAST(VALUE as INTERVAL MONTH)、CAST(VALUE as 
INTERVAL DAY)、
CAST(VALUE as INTERVAL HOUR)、CAST(VALUE as INTERVAL MINUTES)、CAST(VALUE as 
INTERVAL SECOND)
{code}
In postgreSQL：

{code:java}
CAST(VALUE as INTERVAL) ==> CAST(VALUE as INTERVAL SECOND)
select cast('1' as  interval);
select cast('1' as  interval second);
==>00:00:01
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)