[SPARK-28700] make_timestamp loses seconds fractions

• 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: Max Gekk
• Reporter: Max Gekk
• Created: 12/Aug/19 14:41
• Updated: 10/Apr/20 13:48
• Resolved: 13/Aug/19 22:52

Description

The make_timestamp() function accepts seconds with fractional part up to microseconds. In some cases, it can lose precision in the fractional part. For example:

spark-sql> select make_timestamp(2019, 8, 12, 0, 0, 58.000001);
2019-08-12 00:00:58

Issue Links

• links to: GitHub Pull Request #25421