[GitHub] [arrow] DenisTarasyuk opened a new issue, #37608: TO_DATE Gandiva function retruns wrong date for pattern YYYY-MM

["DenisTarasyuk (via GitHub)" <gi...@apache.org>]

DenisTarasyuk opened a new issue, #37608:
URL: https://github.com/apache/arrow/issues/37608

   ### Describe the bug, including details regarding any error messages, version, and platform.
   
   When function TO_DATE is called with pattern 'YYYY-MM' it will return date which has -1 day offset to expected. For example to_date('2022-11', 'YYYY-MM') will return 1667174400000 which is 2022-10-31. Problem is caused by strptime returning 0 in result.tm_mday if day is not part of format. This will cause result to be -1 day from expected. 
   
   ### Component(s)
   
   C++, C++ - Gandiva


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow] kou closed issue #37608: [C++][Gandiva] TO_DATE unction returns wrong date for pattern YYYY-MM

["kou (via GitHub)" <gi...@apache.org>]

kou closed issue #37608: [C++][Gandiva] TO_DATE unction returns wrong date for pattern YYYY-MM
URL: https://github.com/apache/arrow/issues/37608


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org