[
https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811245#comment-17811245
]
Jiajun Xie commented on CALCITE-6222:
-------------------------------------
MariaDB have it: [https://mariadb.com/kb/en/to_char/]
If someone uses it as MySQL, the function will failed.
This change needs to be declared in the Release Notes.
> Mysql does not have to_char function
> ------------------------------------
>
> Key: CALCITE-6222
> URL: https://issues.apache.org/jira/browse/CALCITE-6222
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.37.0
>
>
> {code:java}
> mysql> select to_char(timestamp '2002-04-20 17:31:12.66', 'HH12:MI:SS')
> -> ;
> ERROR 1305 (42000): FUNCTION test.to_char does not exist
> {code}
> mysql does not seem to have a to_char function
>
> link：https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
