[SPARK-29395] Precision of the interval type

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 08/Oct/19 18:09
• Updated: 29/Mar/20 02:15

Description

PostgreSQL allows to specify interval precision, see https://www.postgresql.org/docs/12/datatype-datetime.html

interval [ {{fields ] [ (p) ]}}

16 bytes

time interval

-178000000 years

178000000 years

1 microsecond

For example:

maxim=# SELECT interval '1 2:03.4567' day to second(2);
     interval      
-------------------
 1 day 00:02:03.46
(1 row)