[
https://issues.apache.org/jira/browse/CALCITE-5244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17599737#comment-17599737
]
Julian Hyde commented on CALCITE-5244:
--------------------------------------
My default assumption would be that we support as far as milliseconds - same
grain as TIMESTAMP - but no further.
> Postgres dialect should support traditional postgres interval format
> --------------------------------------------------------------------
>
> Key: CALCITE-5244
> URL: https://issues.apache.org/jira/browse/CALCITE-5244
> Project: Calcite
> Issue Type: Bug
> Components: babel
> Reporter: Dmitry Sysolyatin
> Priority: Major
>
> Postgres dialect should support "Traditional Postgres format" for interval.
> https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-INPUT
> Query {code}select interval '1 year 3 hours 20 minutes 10 seconds 5
> milliseconds'{code} throws exception:
> {code}Caused by: java.lang.RuntimeException:
> org.apache.calcite.sql.parser.SqlParseException: Encountered "\'1 year 3
> hours 20 minutes 10 seconds 5 milliseconds\' <EOF>" at line 1, column
> 17.{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
