[
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
