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

["Sagnik Chakraborty (Jira)" <ji...@apache.org>]

Sagnik Chakraborty created ARROW-9501:
-----------------------------------------

             Summary: [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: Task
            Reporter: Sagnik Chakraborty


{{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)