[
https://issues.apache.org/jira/browse/CALCITE-3619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17001170#comment-17001170
]
Julian Hyde commented on CALCITE-3619:
--------------------------------------
Please use the SQL type name in JIRA summaries: TIMESTAMP WITH TIME ZONE.
I haven't checked the SQL standard, but I suspect that not many data types
allow cast to and from TIMESTAMP WITH TIME ZONE. There are probably conversion
functions that take an explicit time zone. Cast from BIGINT or TIMESTAMP would
have to use the implicit session time zone, and that's probably not a good
thing to do.
Please write down the proposed cast and conversion functions here before you
start work.
> Support TIMESTAMP_WITH_TIME_ZONE in CAST
> ----------------------------------------
>
> Key: CALCITE-3619
> URL: https://issues.apache.org/jira/browse/CALCITE-3619
> Project: Calcite
> Issue Type: Sub-task
> Reporter: Rui Wang
> Priority: Major
>
> Should figure out the CAST relationship between TIMESTAMP_WITH_TIME_ZONE and
> other types, and add the support accordingly.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)