[SPARK-29774] Date and Timestamp type +/- null should be null as Postgres

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 06/Nov/19 11:19
• Updated: 10/Apr/20 13:58
• Resolved: 06/Dec/19 06:54

Description

postgres=# select timestamp '1999-12-31' - null;
 ?column?
----------

(1 row)

postgres=# select date '1999-12-31' - null;
 ?column?
----------

(1 row)

Issue Links

• links to: GitHub Pull Request #26412
• links to: GitHub Pull Request #26932
• links to: GitHub Pull Request #27965