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