[ https://issues.apache.org/jira/browse/CALCITE-6177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17800487#comment-17800487 ]
Caican Cai commented on CALCITE-6177: ------------------------------------- This seems to have been mentioned in mysql8.0. I think you can add a test to sqloperatortest to declare this, such as adding the format_datetime function. > 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)