jnturton commented on issue #2916: URL: https://github.com/apache/drill/issues/2916#issuecomment-2163098978
Drill date and time data types are "naive": they include no time zone information. Whatever time zone applied when the data was written is the only time zone in which they can be correctly understood when they're read again. There are date and time SQL functions that you can use to translate between time zones manually. You can use configuration to change the time zone Drill runs under [1], or change the OS clock timezone, but this will only affect Drill's understanding of the _current_ date and time, e.g. as in `select current_timestamp`, not what it does with timestamps in your data. 1. https://drill.apache.org/docs/data-type-conversion/#time-zone-limitation -- 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: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org