[
https://issues.apache.org/jira/browse/CALCITE-6177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17800327#comment-17800327
]
Tanner Clary commented on CALCITE-6177:
---------------------------------------
I can't speak for MySQL but as far as BigQuery goes, there is some aliasing
between BQ types and Calcite types. A BigQuery {{DATETIME}} is a Calcite
{{TIMESTAMP}} and a BigQuery {{TIMESTAMP}} is a Calcite {{TIMESTAMP WITH LOCAL
TIME ZONE}}. Is this the case for MySQL as well?
> Support datetime type
> ---------------------
>
> Key: CALCITE-6177
> URL: https://issues.apache.org/jira/browse/CALCITE-6177
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Priority: Minor
> Fix For: 1.37.0
>
> Attachments: image-2023-12-25-16-44-55-119.png
>
>
> It seems that the datetime type is not currently supported in calcite. The
> datetime type is a bit different from the timestamp and date types. Is it
> possible to consider supporting it?
>
> [MySQL :: MySQL 8.0 Reference Manual :: 11.2.2 The DATE, DATETIME, and
> TIMESTAMP Types|https://dev.mysql.com/doc/refman/8.0/en/datetime.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
