You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (Jira)" <ji...@apache.org> on 2021/01/04 01:23:00 UTC
[jira] [Commented] (SPARK-33975) add_hours SQL function
[ https://issues.apache.org/jira/browse/SPARK-33975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17257887#comment-17257887 ]
Apache Spark commented on SPARK-33975:
--------------------------------------
User 'MrPowers' has created a pull request for this issue:
https://github.com/apache/spark/pull/31000
> add_hours SQL function
> ----------------------
>
> Key: SPARK-33975
> URL: https://issues.apache.org/jira/browse/SPARK-33975
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 3.1.0
> Reporter: Matthew Powers
> Priority: Minor
>
> This will add an add_hours function that'll make it easier to add and subtract hours from datetime values. Users currently need to manipulate strings and write code like `expr("first_datetime + INTERVAL 2 hours")`. It'll be a lot easier to let them write code like `add_hours(col("first_datetime"), lit(2))`. There's [a Stackoverflow question on this topic with a lot of views|https://stackoverflow.com/questions/40883084/adding-12-hours-to-datetime-column-in-spark], which indicates that this feature will help a lot of users.
> See the [GitHub pull request description|https://github.com/apache/spark/pull/31000] for additional details.
--
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