[
https://issues.apache.org/jira/browse/SPARK-8198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599376#comment-14599376
]
Apache Spark commented on SPARK-8198:
-------------------------------------
User 'adrian-wang' has created a pull request for this issue:
https://github.com/apache/spark/pull/6987
> date/time function: months_between
> ----------------------------------
>
> Key: SPARK-8198
> URL: https://issues.apache.org/jira/browse/SPARK-8198
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Reporter: Reynold Xin
>
> months_between(date1, date2): double
> Returns number of months between dates date1 and date2 (as of Hive 1.2.0). If
> date1 is later than date2, then the result is positive. If date1 is earlier
> than date2, then the result is negative. If date1 and date2 are either the
> same days of the month or both last days of months, then the result is always
> an integer. Otherwise the UDF calculates the fractional portion of the result
> based on a 31-day month and considers the difference in time components date1
> and date2. date1 and date2 type can be date, timestamp or string in the
> format 'yyyy-MM-dd' or 'yyyy-MM-dd HH:mm:ss'. The result is rounded to 8
> decimal places. Example: months_between('1997-02-28 10:30:00', '1996-10-30')
> = 3.94959677
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
