[ 
https://issues.apache.org/jira/browse/SPARK-29408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maxim Gekk updated SPARK-29408:
-------------------------------
    Description: 
For example:
{code}
maxim=# select -interval '1 day -1 hour';
     ?column?
-------------------
 -1 days +01:00:00
(1 row)

maxim=# select - interval '1-2' AS "negative year-month";
 negative year-month 
---------------------
 -1 years -2 mons
(1 row)
{code}

  was:
For example:
{code}
maxim=# select - interval '1-2' AS "negative year-month";
 negative year-month 
---------------------
 -1 years -2 mons
(1 row)
{code}


> Support interval literal with negative sign `-`
> -----------------------------------------------
>
>                 Key: SPARK-29408
>                 URL: https://issues.apache.org/jira/browse/SPARK-29408
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Maxim Gekk
>            Priority: Major
>
> For example:
> {code}
> maxim=# select -interval '1 day -1 hour';
>      ?column?
> -------------------
>  -1 days +01:00:00
> (1 row)
> maxim=# select - interval '1-2' AS "negative year-month";
>  negative year-month 
> ---------------------
>  -1 years -2 mons
> (1 row)
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to