# Date format with timezone offset **URL:** \ **Category:** Elasticsearch\ **Created:** [May 7, 2020, 3:17pm UTC](https://discuss.elastic.co/t/date-format-with-timezone-offset/231576 "2020-05-07T15:17:10Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Xavier\_Romero](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavier_romero/32/63274_2.png) [@Xavier\_Romero](https://discuss.elastic.co/u/Xavier_Romero)\ **Post date:** [May 7, 2020, 3:17pm UTC](https://discuss.elastic.co/t/date-format-with-timezone-offset/231576/1 "2020-05-07T15:17:10Z")
Hi there, Having a hard time to parse a date with zone offset. I need to parse dates like this: "2020-05-07 13:16:44+00:00" So far, I've tried: ``` PUT /_template/test { "index_patterns": ["test"], "mappings": { "properties": { "date1": { "type": "date", "format": "yyyy-MM-dd HH:mm:ssZ" }, "date2": { "type": "date", "format": "yyyy-MM-dd HH:mm:ssZZ" }, "date3": { "type": "date", "format": "yyyy-MM-dd HH:mm:ssZZZ" }, "date4": { "type": "date", "format": "yyyy-MM-dd HH:mm:ssZZZZ" } } } } PUT /test/_doc/1 { "date1": "2020-05-07 13:16:44+00:00" } PUT /test/_doc/1 { "date2": "2020-05-07 13:16:44+00:00" } PUT /test/_doc/1 { "date3": "2020-05-07 13:16:44+00:00" } PUT /test/_doc/1 { "date4": "2020-05-07 13:16:44+00:00" } ``` Every attempt fails because the date can't be parsed (example error for the first case, all looks the same). ``` { "error" : { "root_cause" : [ { "type" : "mapper_parsing_exception", "reason" : "failed to parse field [date1] of type [date] in document with id '1'. Preview of field's value: '2020-05-07 13:16:44+00:00'" } ], "type" : "mapper_parsing_exception", "reason" : "failed to parse field [date1] of type [date] in document with id '1'. Preview of field's value: '2020-05-07 13:16:44+00:00'", "caused_by" : { "type" : "illegal_argument_exception", "reason" : "failed to parse date field [2020-05-07 13:16:44+00:00] with format [yyyy-MM-dd HH:mm:ssZ]", "caused_by" : { "type" : "date_time_parse_exception", "reason" : "Text '2020-05-07 13:16:44+00:00' could not be parsed at index 19" } } }, "status" : 400 } ``` ..... Please, which is the right format I need to use? Thank you very much. ---
**Author:** ![cbuescher](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cbuescher/32/60402_2.png) [@cbuescher](https://discuss.elastic.co/u/cbuescher)\ **Post date:** [May 7, 2020, 4:04pm UTC](https://discuss.elastic.co/t/date-format-with-timezone-offset/231576/2 "2020-05-07T16:04:48Z")
Assuming this is on some late 7.x version, according to the java [the docs](https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html) that we link from our [format docs](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html), five is the magic number in this case: > **Offset Z** : This formats the offset based on the number of pattern letters. One, two or three letters outputs the hour and minute, without a colon, such as '+0130'. The output will be '+0000' when the offset is zero. Four letters outputs the [full](https://docs.oracle.com/javase/8/docs/api/java/time/format/TextStyle.html#FULL) form of localized offset, equivalent to four letters of Offset-O. The output will be the corresponding localized offset text if the offset is zero. **Five letters outputs the hour, minute, with optional second if non-zero, with colon.** It outputs 'Z' if the offset is zero. Six or more letters throws `IllegalArgumentException` . This at least works for me on 7.6.2 ```auto DELETE test PUT /_template/test { "index_patterns": ["test"], "mappings": { "properties": { "date": { "type": "date", "format": "yyyy-MM-dd HH:mm:ssZZZZZ" } } } } PUT /test/_doc/1 { "date1": "2020-05-07 13:16:44+00:00" } GET /test/_search { "docvalue_fields": ["date"] }) ``` Formatting is also often weird to me, I keep re-reading those docs and need to try things every time, and zone offsets are especially hard. Hope this helps. ---
**Author:** ![Xavier\_Romero](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavier_romero/32/63274_2.png) [@Xavier\_Romero](https://discuss.elastic.co/u/Xavier_Romero)\ **Post date:** [May 7, 2020, 5:10pm UTC](https://discuss.elastic.co/t/date-format-with-timezone-offset/231576/3 "2020-05-07T17:10:05Z")
Great @cbuescher, that worked as expected! As you said, really confusing, since somewhere I've documentation where my exact example was supposed to work with ZZ, somewhere else with ZZZZ... Thank you very much. ---
**Author:** ![cbuescher](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cbuescher/32/60402_2.png) [@cbuescher](https://discuss.elastic.co/u/cbuescher)\ **Post date:** [May 7, 2020, 6:07pm UTC](https://discuss.elastic.co/t/date-format-with-timezone-offset/231576/4 "2020-05-07T18:07:41Z")
With these things its always important to know the exact ES version, since we switched dates from Joda-time to Java time in version 7 and although the format syntax is _mostly_ the same, there are important differences. See [https://www.elastic.co/guide/en/elasticsearch/reference/7.x/breaking-changes-7.0.html#breaking\_70\_java\_time\_changes](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/breaking-changes-7.0.html#breaking_70_java_time_changes) as an introduction. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 4, 2020, 6:07pm UTC](https://discuss.elastic.co/t/date-format-with-timezone-offset/231576/5 "2020-06-04T18:07:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.