spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyukjin Kwon (Jira)" <j...@apache.org>
Subject [jira] [Resolved] (SPARK-29365) Support date and timestamp subtraction
Date Mon, 07 Oct 2019 07:48:00 GMT

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

Hyukjin Kwon resolved SPARK-29365.
----------------------------------
    Fix Version/s: 3.0.0
       Resolution: Fixed

Issue resolved by pull request 26036
[https://github.com/apache/spark/pull/26036]

> Support date and timestamp subtraction 
> ---------------------------------------
>
>                 Key: SPARK-29365
>                 URL: https://issues.apache.org/jira/browse/SPARK-29365
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 2.4.4
>            Reporter: Maxim Gekk
>            Priority: Minor
>             Fix For: 3.0.0
>
>
> PostgreSQL supports subtraction dates and timestamps:
> {code}
> maxim=# select date'2020-01-01' - timestamp'2019-10-06 10:11:12.345678';
>         ?column?         
> -------------------------
>  86 days 13:48:47.654322
> (1 row)
> maxim=# select timestamp'2019-10-06 10:11:12.345678' - date'2020-01-01';
>          ?column?          
> ---------------------------
>  -86 days -13:48:47.654322
> (1 row)
> {code}
> Need to provide the same feature in Spark SQL.



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

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


Mime
View raw message