[ARROW-16738] [C++][Gandiva] Fix TO_TIMESTAMP(INTEGER) function for big integer values

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 9.0.0
• Component/s: C++, C++ - Gandiva
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/32076
• Assignee: Anthony Louis Gotlib Ferreira
• Reporter: Anthony Louis Gotlib Ferreira
• Created: 02/Jun/22 13:53
• Updated: 11/Jan/23 11:46
• Resolved: 14/Jun/22 13:57

Description

When to_timestamp function gets a big value, the function returns an incorrect date due integer overflow:

• TO_TIMESTAMP(1626255099[INT32]) -> '1969-12-14 04:54:53.816'

 

The correct response should be:

• TO_TIMESTAMP(1626255099[INT32]) -> '2021-07-14 09:31:39'

Issue Links

• links to: GitHub Pull Request #13298