Elasticsearch query based on timestamp

Question

This is my elasticsearch query that intends to filter data between 11 pm and 12 pm on the day 2015.08.04. But it doesn't filter and gives many errors.

"query" : {"range" :
            {"@timestamp" :
              {"gt" : "2015-08-04  11:00:00", "lt" : "2015-08-04 12:00:00"} 
            } 
          }

What error did you see?, and can you reformat your query, it's really hard to read. — Ryan Huynh.
– Ryan Huynh., Commented Sep 17, 2015 at 0:46

hpaknia · Accepted Answer · 2017-09-19 00:59:23Z

52

It works with the following query

{
   "query":{
      "range":{
         "@timestamp":{
            "gte":"2015-08-04T11:00:00",
            "lt":"2015-08-04T12:00:00"
         }
      }
   }
}

edited Sep 19, 2017 at 0:59

hpaknia

3,1285 gold badges37 silver badges72 bronze badges

answered Sep 17, 2015 at 0:56

Pooja

8831 gold badge7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Torque Over a year ago

What makes you think that, @NasserTahani ? The @ is part of the @timestamp variables name, and the query works correctly with it.

Collectives™ on Stack Overflow

Elasticsearch query based on timestamp

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related