[SPARK-27898] Support 4 date operators(date + integer, integer + date, date - integer and date - date)

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Yuming Wang
• Reporter: Yuming Wang
• Created: 31/May/19 13:54
• Updated: 10/Apr/20 14:03
• Resolved: 05/Jul/19 17:03

Description

Support 4 date operators(date + integer, integer + date, date - integer and date - date):

Operator	Example	Result
+	date '2001-09-28' + integer '7'	date '2001-10-05'
-	date '2001-10-01' - integer '7'	date '2001-09-24'
-	date '2001-10-01' - date '2001-09-28'	integer '3' (days)

https://www.postgresql.org/docs/12/functions-datetime.html

Issue Links

• relates to: SPARK-28425 Add more Date/Time Operators
• relates to: SPARK-29355 Support timestamps subtraction
• links to: GitHub Pull Request #24755