[SPARK-29388] Construct intervals from the `millenniums`, `centuries` or `decades` units

• 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 10:43
• Updated: 29/Mar/20 02:16

Description

PostgreSQL supports `millenniums`, `centuries` or `decades` interval units. See

maxim=# select '4 millenniums 5 centuries 4 decades 1 year 4 months 4 days 17 minutes 31 seconds'::interval;
             interval              
-----------------------------------
 4541 years 4 mons 4 days 00:17:31
(1 row)