[SPARK-34737] Discrepancy between TIMESTAMP_SECONDS and cast from float

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.1.2, 3.2.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 14/Mar/21 07:46
• Updated: 12/Dec/22 18:11
• Resolved: 15/Mar/21 01:06

Description

TIMESTAMP_SECONDS and CAST(<float> AS TIMESTAMP) have different results:

spark-sql> SELECT CAST(16777215.0f AS TIMESTAMP);
1970-07-14 07:20:15
spark-sql> SELECT TIMESTAMP_SECONDS(16777215.0f);
1970-07-14 07:20:14.951424

Issue Links

• relates to: SPARK-34727 Difference in results of casting float to timestamp
• links to: [Github] Pull Request #31831 (MaxGekk)
• links to: [Github] Pull Request #31831 (MaxGekk)
• links to: [Github] Pull Request #31872 (MaxGekk)