[jira] [Commented] (CALCITE-3619) Support TIMESTAMP_WITH_TIME_ZONE in CAST

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ 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)