[
https://issues.apache.org/jira/browse/CALCITE-5654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Nieradzik updated CALCITE-5654:
-----------------------------------
Summary: Support PostgreSQL's syntax for day-to-second intervals (was:
Support PostgreSQL's interval syntax)
> Support PostgreSQL's syntax for day-to-second intervals
> -------------------------------------------------------
>
> Key: CALCITE-5654
> URL: https://issues.apache.org/jira/browse/CALCITE-5654
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Tim Nieradzik
> Assignee: Tim Nieradzik
> Priority: Minor
>
> Support day-to-second intervals using PostgreSQL's syntax:
> select INTERVAL '2 weeks 3 days 4 hours 5 minutes 6 seconds 7 milliseconds'
> select INTERVAL '-30 day'
> These should be equivalent to:
> select INTERVAL '17 04:05:06.007' DAY TO SECOND
> select -INTERVAL '30 00:00:00.000' DAY TO SECOND
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
