[
https://issues.apache.org/jira/browse/CALCITE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681172#comment-17681172
]
Julian Hyde commented on CALCITE-759:
-------------------------------------
[~mbudiu], Regarding "dialect". The {{SqlDialect}} class controls how Calcite's
JDBC adapter generates SQL to be sent to another system; it does not control
the behavior of incoming SQL. The {{library}} connection property allows you to
add extra functions to the operator set used by Calcite's parser/validator but
it doesn't generally change the behavior of standard functions, of which
{{EXTRACT}} is one. So, adding a configuration parameter to change the behavior
of {{EXTRACT}} would be problematic. I hope it doesn't come to that.
> Add DayOfWeek and other missing date/time functions
> ---------------------------------------------------
>
> Key: CALCITE-759
> URL: https://issues.apache.org/jira/browse/CALCITE-759
> Project: Calcite
> Issue Type: Bug
> Components: babel
> Reporter: Julian Hyde
> Priority: Major
> Labels: dialect, newbie
>
> Calcite implements EXTRACT, FLOOR, CEIL, CAST, +, - on date/time values and
> much can be accomplished with these. But there are other useful functions in
> other databases.
> For example MySQL has DayOfWeek. See
> https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html. It is
> tricky to achieve the same in Calcite (you'd need to subtract the epoch and
> take the interval modulo 7).
> We need to review the date/time functions in MySQL, Postgres and Oracle, and
> add functions to ensure that you can accomplish the same things in Calcite
> fairly easily.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
