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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: C++ - Gandiva
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/17283
• Assignee: Sagnik Chakraborty
• Reporter: Sagnik Chakraborty
• Created: 16/Jul/20 03:20
• Updated: 11/Jan/23 08:07
• Resolved: 20/Jul/20 11:46

Description

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.

Issue Links

• links to: GitHub Pull Request #7782