[
https://issues.apache.org/jira/browse/CALCITE-7021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated CALCITE-7021:
----------------------------------------
Description:
Now we have supported :
{code:java}
CAST(VALUE as INTERVAL YEAR)、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}
was:
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}
> 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
> Priority: Major
>
> Now we have supported :
> {code:java}
> CAST(VALUE as INTERVAL YEAR)、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)
