[SPARK-30843] Wrong results of getting time components before 1582 year

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 16/Feb/20 07:58
• Updated: 19/Feb/20 05:18
• Resolved: 17/Feb/20 09:01

Description

Here are example that show the issues:

spark-sql> select hour(timestamp '0010-01-01 00:00:00');
23
spark-sql> select minute(timestamp '0010-01-01 00:00:00');
52
spark-sql> select second(timestamp '0010-01-01 00:00:00');
58
spark-sql> select date_part('milliseconds', timestamp '0010-01-01 00:00:00');
58000.000
spark-sql> select date_part('microseconds', timestamp '0010-01-01 00:00:00');
58000000

The expected results must be:

• hour = 0
• minute = 0
• second = 0
• milliseconds = 0
• microseconds = 0

Issue Links

• links to: GitHub Pull Request #27596