[SPARK-29311] Return seconds with fraction from `date_part`/`extract`

• 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: Max Gekk
• Reporter: Max Gekk
• Created: 01/Oct/19 08:57
• Updated: 12/Dec/22 18:10
• Resolved: 02/Oct/19 02:17

Description

The `date_part()` and `extract` should return seconds with fractional part for the `SECOND` field as PostgreSQL does:

# SELECT date_part('SECONDS', timestamp'2019-10-01 00:00:01.000001');
 date_part 
-----------
  1.000001
(1 row)

Issue Links

• links to: GitHub Pull Request #25986
• links to: GitHub Pull Request #28140