[ https://issues.apache.org/jira/browse/CALCITE-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15583367#comment-15583367 ]
Julian Hyde commented on CALCITE-1444: -------------------------------------- This would be great. Note that the SQL standard has a {{CONVERT}} function (see CALCITE-111) which has a different purpose (it relates to character sets). Since it is specified without the {{ {fn ...} }} syntax, they should be able to coexist. > Add support for CONVERT scalar function > --------------------------------------- > > Key: CALCITE-1444 > URL: https://issues.apache.org/jira/browse/CALCITE-1444 > Project: Calcite > Issue Type: Improvement > Components: core > Reporter: Laurent Goujon > Assignee: Julian Hyde > > Both ODBC and JDBC spec mention a {{CONVERT}} scalar function, which is the > equivalent of the {{CAST}} function. > In order for JDBC and ODBC drivers to expose support for this function, > calcite should support parsing it, and converting it into a {{CAST}} > expression (currently, it doesn't unlike some other scalar functions). -- This message was sent by Atlassian JIRA (v6.3.4#6332)