[ https://issues.apache.org/jira/browse/CALCITE-5301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17610695#comment-17610695 ]
Julian Hyde commented on CALCITE-5301: -------------------------------------- This would require supporting the {{TIMESTAMP WITH TIME ZONE}} data type, right? A couple of notes on Jira formatting. You can just write a jira case number, e.g. CALCITE-3238. For monospaced font use brace-brace not backtick. Can you fix the description, please. > Support AT TIME ZONE > -------------------- > > Key: CALCITE-5301 > URL: https://issues.apache.org/jira/browse/CALCITE-5301 > Project: Calcite > Issue Type: New Feature > Components: core > Reporter: Rong Rong > Priority: Major > > Calcite already supports WITH TIME ZONE suffix in: > https://issues.apache.org/jira/browse/CALCITE-3238 > a slightly different syntax supported by many is: `AT TIME ZONE` > see: > - > https://www.postgresql.org/docs/14/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT > - > https://prestodb.io/docs/current/functions/datetime.html#time-zone-conversion > would it be possible to support this syntax that converts a TIMESTAMP with > time zone to another timezone? -- This message was sent by Atlassian Jira (v8.20.10#820010)