Omega359 commented on issue #686: URL: https://github.com/apache/arrow-datafusion/issues/686#issuecomment-1938746022
Spark has a [couple of functions](https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html#date-and-timestamp-functions) that I think might be useful in this context: - convert_timezone([sourceTz, ]targetTz, sourceTs) - converts a timestamp without a tz from the given source tz to the target tz - from_utc_timestamp(timestamp, timezone) - takes a timestamp in UTC and converts it to the given tz Postgresql [provides the following](https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT): - timestamp without time zone AT TIME ZONE zone - timestamp with time zone AT TIME ZONE zone - timezone(zone, timestamp) / timestamp AT TIME ZONE zone -- 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]
