[CALCITE-6612] Add DATE_SUB function (enabled in Spark library)

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.38.0
• Fix Version/s: 1.39.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Caican Cai
• Reporter: Caican Cai
• Created: 06/Oct/24 15:51
• Updated: 1 week ago 17:56
• Resolved: 1 week ago 17:56

Description

https://spark.apache.org/docs/3.5.2/sql-ref-functions-builtin.html#date-and-timestamp-functions

scala> val df = spark.sql("select date_sub('2016-07-30', 1)")
df: org.apache.spark.sql.DataFrame = [date_sub(2016-07-30, 1): date]

scala> df.show()
+-----------------------+
|date_sub(2016-07-30, 1)|
+-----------------------+
|             2016-07-29|
+-----------------------+

Issue Links

• Blocked: CALCITE-6544 Calcite's bigquery Dialect date_add and date_sub functions allow 0000 and BC as results
• Blocked: CALCITE-6527 Add DATE_ADD function (enabled in Spark library)
• Blocked: CALCITE-6396 Add ADD_MONTHS function (enabled in Oracle, Spark library)
• links to: GitHub Pull Request #3995