[
https://issues.apache.org/jira/browse/CALCITE-6396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872646#comment-17872646
]
Caican Cai edited comment on CALCITE-6396 at 8/11/24 1:28 AM:
--------------------------------------------------------------
[~julianhyde] Hello, I have a confusion here. In Spark, the second parameter n
in ADD_MONTHS(d, n) supports string, double and other types, but calcite does
not support date function calculations.
In my understanding, this should not be in line with the SQL standard. Should
we support it? I think if we support it, it may be a disaster.
was (Author: JIRAUSER302115):
[~julianhyde] Hello, I have a confusion here. The second parameter n in
ADD_MONTHS(d, n) supports string, double and other types, but calcite does not
support date function calculations.
In my understanding, this should not be in line with the SQL standard. Should
we support it? I think if we support it, it may be a disaster.
> Add ADD_MONTHS function (enabled in Spark library)
> --------------------------------------------------
>
> Key: CALCITE-6396
> URL: https://issues.apache.org/jira/browse/CALCITE-6396
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.38.0
>
>
> Add ADD_MONTHS function (enabled in Spark library)
>
> https://spark.apache.org/docs/2.3.0/api/sql/index.html#add_months
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
