[jira] [Assigned] (ARROW-9501) [C++][Gandiva] Add logic in timestampdiff() when end date is last day of a month

["Neal Richardson (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ARROW-9501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Neal Richardson reassigned ARROW-9501:
--------------------------------------

    Assignee: Sagnik Chakraborty

> [C++][Gandiva] Add logic in timestampdiff() when end date is last day of a month
> --------------------------------------------------------------------------------
>
>                 Key: ARROW-9501
>                 URL: https://issues.apache.org/jira/browse/ARROW-9501
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: C++ - Gandiva
>            Reporter: Sagnik Chakraborty
>            Assignee: Sagnik Chakraborty
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.0.0
>
>          Time Spent: 1h 20m
>  Remaining Estimate: 0h
>
> {{timestampdiff}}(*month*, _startDate_, _endDate_) returns wrong result in Gandiva when the _endDate_ < _startDate_ and _endDate_ is the last day of the month. An additional month is said to have passed when the end day is greater than or equal to the start day, but this does not hold true for dates which are last days of the month.
> Case in point, if _startDate_ = *2020-01-31*, _endDate_ = *2020-02-29*, previously {{timestampdiff}}() returned *0*, but the correct result should be *1*.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)