alamb commented on issue #7802: URL: https://github.com/apache/arrow-datafusion/issues/7802#issuecomment-1761691529
I agree the difference with postgres seems related to the fact that `to_timestamp` takes an argument in terms of second for postgres, and nanoseconds for datafusion: https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TABLE ``` to_timestamp ( double precision ) → timestamp with time zone Convert Unix epoch (seconds since 1970-01-01 00:00:00+00) to timestamp with time zone to_timestamp(1284352323) → 2010-09-13 04:32:03+00 ``` -- 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]
