# Unknown time-zone ID: strict\_date\_hour\_minute\_second

**URL:** <https://discuss.elastic.co/t/unknown-time-zone-id-strict-date-hour-minute-second/277933>\
**Category:** Elasticsearch\
**Created:** [July 6, 2021, 8:42am UTC](https://discuss.elastic.co/t/unknown-time-zone-id-strict-date-hour-minute-second/277933 "2021-07-06T08:42:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![wajika](https://avatars.discourse-cdn.com/v4/letter/w/977dab/32.png) [@wajika](https://discuss.elastic.co/u/wajika)\
**Post date:** [July 6, 2021, 8:42am UTC](https://discuss.elastic.co/t/unknown-time-zone-id-strict-date-hour-minute-second/277933/1 "2021-07-06T08:42:25Z")

</div>

I read the document and wrote a DSL query, but there was an error.

What is a time zone ID? It's not mentioned in the document.

> quote doc  
> `date_hour_minute_second` or `strict_date_hour_minute_second`  
> A formatter that combines a full date, two digit hour of day, two digit minute of hour, and two digit second of minute: `yyyy-MM-dd'T'HH:mm:ss` .

```auto
GET /_search
{
  "size":1,
  "query": {
    "range": {
      "@timestamp": {
        "time_zone": "strict_date_hour_minute_second",        
        "gte": "2021-06-21T00:00:00Z", 
        "lte": "2021-06-27T23:59:59Z"                  
      }
    }
  }
}

```

```auto
{
  "error" : {
    "root_cause" : [
      {
        "type" : "illegal_argument_exception",
        "reason" : "java.time.zone.ZoneRulesException: Unknown time-zone ID: strict_date_hour_minute_second"
      }
    ],
    "type" : "illegal_argument_exception",
    "reason" : "java.time.zone.ZoneRulesException: Unknown time-zone ID: strict_date_hour_minute_second",
    "caused_by" : {
      "type" : "zone_rules_exception",
      "reason" : "Unknown time-zone ID: strict_date_hour_minute_second"
    }
  },
  "status" : 400
}

```

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [July 7, 2021, 2:47pm UTC](https://discuss.elastic.co/t/unknown-time-zone-id-strict-date-hour-minute-second/277933/2 "2021-07-07T14:47:33Z")

</div>

You are probably mixing the time `format` with the `time_zone` parameter... a timezone is something like `CET` or `CEST`, where as the format describes how a date looks like.

Hope this helps!

---

<div class="post-metadata">

**Author:** ![wajika](https://avatars.discourse-cdn.com/v4/letter/w/977dab/32.png) [@wajika](https://discuss.elastic.co/u/wajika)\
**Post date:** [July 7, 2021, 11:56pm UTC](https://discuss.elastic.co/t/unknown-time-zone-id-strict-date-hour-minute-second/277933/3 "2021-07-07T23:56:51Z")

</div>

Sorry, I made a very simple mistake. Thanks for your answer.

---

<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:** [August 4, 2021, 11:57pm UTC](https://discuss.elastic.co/t/unknown-time-zone-id-strict-date-hour-minute-second/277933/4 "2021-08-04T23:57:05Z")

</div>

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