Hi, I want to create a query that returns all the data from last 3 days and only between 09:00 AM - 18:00 PM. My date field contains both the date and the time of the day (For example "time" : "2019-08-06T06:40:55Z"). Can I do something like or how can I achieve this with this mapping (Elastic ve…

How to filter date field by days and hours separately

spinscale (Alexander Reelsen) August 6, 2019, 12:03pm 4

you just take the minute into account as well, then you can model sth like 9:30. The date is always stored as UTC, you need to calculate offsets yourself.

Time of Day filter

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.