I have my_datetime and time_zone fields (my_datetime is a datetime UTC field and time_zone is the string version of the timezone, eg "Europe/Paris". I currently use the AT TIME ZONE function in postgres to transform dates on the fly in my where clause. Eg WHERE my_datetime AT TIME ZONE 'Europe/…

Timezone affected dates

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Timezone affected dates