# Datetime hour search query

**URL:** <https://discuss.elastic.co/t/datetime-hour-search-query/213298>\
**Category:** Elasticsearch\
**Created:** [December 29, 2019, 10:08pm UTC](https://discuss.elastic.co/t/datetime-hour-search-query/213298 "2019-12-29T22:08:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kopiko](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Kopiko](https://discuss.elastic.co/u/Kopiko)\
**Post date:** [December 29, 2019, 10:08pm UTC](https://discuss.elastic.co/t/datetime-hour-search-query/213298/1 "2019-12-29T22:08:53Z")

</div>

Hello,

I'm just starting to use Elastic and having trouble parsing datetime data. In Python, I'm trying to create a query that puts out all documents for which the hour value in the field 'datetime' equals 11. Been trying to go along many routes, but so far no luck.

My mapping is as follows:

```
settings = {
   'settings': {
        "number_of_shards" : 1
   },
   'mappings': {
    'properties': {
        'datetime': {'type': 'date', "format": "yyyy-MM-dd HH:mm:ss" },
    }
  }
}

```

Hope you guys can help me out. Thank you.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 26, 2020, 10:08pm UTC](https://discuss.elastic.co/t/datetime-hour-search-query/213298/2 "2020-01-26T22:08:57Z")

</div>

Closed on January 26, 2020, 10:08pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.