[ 
https://issues.apache.org/jira/browse/HIVE-9518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14299258#comment-14299258
 ] 

Jason Dere commented on HIVE-9518:
----------------------------------

Left some comments on RB.
Also, can you add a q-file test using months_between() in a SQL query?

> Implement MONTHS_BETWEEN aligned with Oracle one
> ------------------------------------------------
>
>                 Key: HIVE-9518
>                 URL: https://issues.apache.org/jira/browse/HIVE-9518
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Xiaobing Zhou
>            Assignee: Xiaobing Zhou
>         Attachments: HIVE-9518.1.patch, HIVE-9518.2.patch
>
>
> This is used to track work to build Oracle like months_between. Here's 
> semantics:
> MONTHS_BETWEEN returns number of months between dates date1 and date2. 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 Oracle Database calculates the fractional portion of 
> the result based on a 31-day month and considers the difference in time 
> components date1 and date2.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to