rok commented on issue #38488:
URL: https://github.com/apache/arrow/issues/38488#issuecomment-1782876673

   This is a gotcha I hit myself occasionally. While `date64` stores dates with 
millisecond precision it still stores them rounded to day, so your timestamp 
gets rounded (floored) to nearest midnight. A more natural choice of unit here 
would be pa.timestamp("ms").
   See arrow's definition of `date64` below:
   
https://github.com/apache/arrow/blob/6e6fd0a30aebee6738bb4bb703344f0c866debea/format/Schema.fbs#L240-L253


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to