[
https://issues.apache.org/jira/browse/SPARK-8198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Owen updated SPARK-8198:
-----------------------------
Assignee: Adrian Wang
> 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
> Assignee: Adrian Wang
> Fix For: 1.5.0
>
>
> 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: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
