[SPARK-29370] Interval strings without explicit unit markings

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

Description

In PostgreSQL, Quantities of days, hours, minutes, and seconds can be specified without explicit unit markings. For example, '1 12:59:10' is read the same as '1 day 12 hours 59 min 10 sec'. For example:

maxim=# select interval '1 12:59:10';
    interval    
----------------
 1 day 12:59:10
(1 row)

It should allow to specify the sign:

maxim=# SELECT interval '1 +2:03:04' minute to second;
    interval    
----------------
 1 day 02:03:04
maxim=# SELECT interval '1 -2:03:04' minute to second;
    interval     
-----------------
 1 day -02:03:04