I store all my documents with date/times in GMT. Then at query time I use the "time_zone" property of a date_histogram to choose which timezone to localize it to (we have users in multiple time zones). This works great; however, I have ran into a problem for queries that span the daylight saving ti…

Handling 1d date_histogram queries that span Daylight Saving Time (Nov 6th 2 am)

warkolm (Mark Walkom) December 27, 2016, 7:26pm 4

Oh, there you go!

Topic		Replies	Views
Handling Time Zones and Daylight saving time Elasticsearch	3	5020	May 25, 2017
Datehistogram on DayLightSaving time range produces wrong buckets Elasticsearch aggregations	2	185	May 14, 2024
When i use date_histogram it use utc time Elasticsearch	4	458	May 14, 2018
Minus timezone on date histogram aggregation shifts back buckets one day Elasticsearch	1	312	March 2, 2021
Timezones in date histograms, redux Elasticsearch	3	559	July 6, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

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.

Handling 1d date_histogram queries that span Daylight Saving Time (Nov 6th 2 am)

Related topics