[ https://issues.apache.org/jira/browse/ARROW-13281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
João Pedro Antunes Ferreira updated ARROW-13281: ------------------------------------------------ Description: The TIMESTAMPDIFF function appears to return incorrect values when a negative number should be returned. Example: - For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-03-31") it should return *-3**,* but it returns *-1* - For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-05-31") it should return *-1**,* but it returns *1* was: The TIMESTAMPDIFF function appears to return incorrect values when a negative number should be returned. Example: - For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-03-31") it should return **-3***, but it returns *-1** - For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-05-31") it should return **-1***, but it returns *1** > [C++][Gandiva] Error on timestampDiffMonth function behavior for negative > diff values > ------------------------------------------------------------------------------------- > > Key: ARROW-13281 > URL: https://issues.apache.org/jira/browse/ARROW-13281 > Project: Apache Arrow > Issue Type: Bug > Components: C++ - Gandiva > Reporter: João Pedro Antunes Ferreira > Assignee: João Pedro Antunes Ferreira > Priority: Minor > Labels: pull-request-available > Time Spent: 20m > Remaining Estimate: 0h > > The TIMESTAMPDIFF function appears to return incorrect values when a negative > number should be returned. > Example: > - For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-03-31") it should > return *-3**,* but it returns *-1* > - For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-05-31") it should > return *-1**,* but it returns *1* -- This message was sent by Atlassian Jira (v8.3.4#803005)