[SPARK-29365] Support date and timestamp subtraction

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.4.4
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 06/Oct/19 18:00
• Updated: 12/Dec/22 18:10
• Resolved: 07/Oct/19 07:47

Description

PostgreSQL supports subtraction dates and timestamps:

maxim=# select date'2020-01-01' - timestamp'2019-10-06 10:11:12.345678';
        ?column?         
-------------------------
 86 days 13:48:47.654322
(1 row)

maxim=# select timestamp'2019-10-06 10:11:12.345678' - date'2020-01-01';
         ?column?          
---------------------------
 -86 days -13:48:47.654322
(1 row)

Need to provide the same feature in Spark SQL.

Issue Links

• links to: GitHub Pull Request #26036