You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Wenchen Fan (Jira)" <ji...@apache.org> on 2021/04/27 13:08:00 UTC

[jira] [Resolved] (SPARK-35091) Support ANSI intervals by date_part()

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

Wenchen Fan resolved SPARK-35091.
---------------------------------
    Fix Version/s: 3.2.0
       Resolution: Fixed

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

> Support ANSI intervals by date_part()
> -------------------------------------
>
>                 Key: SPARK-35091
>                 URL: https://issues.apache.org/jira/browse/SPARK-35091
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.2.0
>            Reporter: Max Gekk
>            Assignee: Kent Yao
>            Priority: Major
>             Fix For: 3.2.0
>
>
> Support year-month and day-time intervals by date_part(). For example:
> {code:sql}
>       > SELECT date_part('days', interval '5 0:0:0' day to second);
>        5
>       > SELECT date_part('seconds', interval '10 11:12:30.001001' DAY TO SECOND);
>        30.001001
> {code}



--
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