# ES unable to parse ISODateTimeFormat?

**URL:** <https://discuss.elastic.co/t/es-unable-to-parse-isodatetimeformat/7577>\
**Category:** Elasticsearch\
**Created:** [May 6, 2012, 8:05pm UTC](https://discuss.elastic.co/t/es-unable-to-parse-isodatetimeformat/7577 "2012-05-06T20:05:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bilash](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@bilash](https://discuss.elastic.co/u/bilash)\
**Post date:** [May 6, 2012, 8:05pm UTC](https://discuss.elastic.co/t/es-unable-to-parse-isodatetimeformat/7577/1 "2012-05-06T20:05:28Z")

</div>

I am trying to index the following JSON document:

{"post" : "I am going to go to london next month",  
"postId" : "0",  
"username" : "bilash1",  
"postTime" : "2012-05-06T15:32:12",  
}

But I get the following date format errors:

org.elasticsearch.index.mapper.MapperParsingException: Failed to parse  
[postTime]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
320) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
580) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
444) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
473) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
417) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.shard.service.InternalIndexShard.prepareCreate(InternalIndexShard.java:  
290) ~[elasticsearch-0.19.1.jar:na]  
Caused by: org.elasticsearch.index.mapper.MapperParsingException:  
failed to parse date field [2012-05-06T15:32:12], tried both date  
format [yyyy-MM-d  
d HH-mm-ss], and timestamp number  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:  
412) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:  
341) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
307) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
580) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
444) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
473) ~[elasticsearch-0.19.1.jar:na]  
Caused by: java.lang.IllegalArgumentException: Invalid format:  
"2012-05-06T15:32:12" is malformed at "T15:32:12"  
at  
org.elasticsearch.common.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:  
644) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:  
406) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:  
341) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
307) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
580) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
444) ~[elasticsearch-0.19.1.jar:na]

This is the ISO datetime format as suggested by Shay. What am I  
missing here?

Thanks!

---

<div class="post-metadata">

**Author:** ![medcl\_net](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@medcl\_net](https://discuss.elastic.co/u/medcl_net)\
**Post date:** [May 7, 2012, 2:26am UTC](https://discuss.elastic.co/t/es-unable-to-parse-isodatetimeformat/7577/2 "2012-05-07T02:26:45Z")

</div>

the data and the format doesn't match:

[2012-05-06T15:32:12]  
yyyy-MM-dd HH-mm-ss

-----Original Message-----  
From: bilash  
Sent: Monday, May 07, 2012 4:05 AM  
To: elasticsearch  
Subject: ES unable to parse ISODateTimeFormat?

I am trying to index the following JSON document:

{"post" : "I am going to go to london next month",  
"postId" : "0",  
"username" : "bilash1",  
"postTime" : "2012-05-06T15:32:12",  
}

But I get the following date format errors:

org.elasticsearch.index.mapper.MapperParsingException: Failed to parse  
[postTime]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
320) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
580) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
444) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
473) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
417) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.shard.service.InternalIndexShard.prepareCreate(InternalIndexShard.java:  
290) ~[elasticsearch-0.19.1.jar:na]  
Caused by: org.elasticsearch.index.mapper.MapperParsingException:  
failed to parse date field [2012-05-06T15:32:12], tried both date  
format [yyyy-MM-d  
d HH-mm-ss], and timestamp number  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:  
412) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:  
341) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
307) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
580) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
444) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
473) ~[elasticsearch-0.19.1.jar:na]  
Caused by: java.lang.IllegalArgumentException: Invalid format:  
"2012-05-06T15:32:12" is malformed at "T15:32:12"  
at  
org.elasticsearch.common.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:  
644) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:  
406) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:  
341) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
307) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
580) ~[elasticsearch-0.19.1.jar:na]  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
444) ~[elasticsearch-0.19.1.jar:na]

This is the ISO datetime format as suggested by Shay. What am I  
missing here?

Thanks!

---

<div class="post-metadata">

**Author:** ![bilash](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@bilash](https://discuss.elastic.co/u/bilash)\
**Post date:** [May 8, 2012, 3:04pm UTC](https://discuss.elastic.co/t/es-unable-to-parse-isodatetimeformat/7577/3 "2012-05-08T15:04:53Z")

</div>

Thanks. Yes, I found out later that the format I used in the mapping  
was missing the T in the middle.

On May 6, 10:26 pm, [medcl2...@gmail.com](mailto:medcl2...@gmail.com) wrote:

> the data and the format doesn't match:
> 
> [2012-05-06T15:32:12]  
> yyyy-MM-dd HH-mm-ss
> 
> -----Original Message-----  
> From: bilash  
> Sent: Monday, May 07, 2012 4:05 AM  
> To: elasticsearch  
> Subject: ES unable to parse ISODateTimeFormat?
> 
> I am trying to index the following JSON document:
> 
> {"post" : "I am going to go to london next month",  
> "postId" : "0",  
> "username" : "bilash1",  
> "postTime" : "2012-05-06T15:32:12",  
> }
> 
> But I get the following date format errors:
> 
> org.elasticsearch.index.mapper.MapperParsingException: Failed to parse  
> [postTime]  
> at  
> org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
> 320) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
> 580) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
> 444) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
> 473) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
> 417) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.shard.service.InternalIndexShard.prepareCreate(InternalIndexShard.java:  
> 290) ~[elasticsearch-0.19.1.jar:na]  
> Caused by: org.elasticsearch.index.mapper.MapperParsingException:  
> failed to parse date field [2012-05-06T15:32:12], tried both date  
> format [yyyy-MM-d  
> d HH-mm-ss], and timestamp number  
> at  
> org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:  
> 412) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:  
> 341) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
> 307) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
> 580) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
> 444) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:  
> 473) ~[elasticsearch-0.19.1.jar:na]  
> Caused by: java.lang.IllegalArgumentException: Invalid format:  
> "2012-05-06T15:32:12" is malformed at "T15:32:12"  
> at  
> org.elasticsearch.common.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:  
> 644) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:  
> 406) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:  
> 341) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:  
> 307) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:  
> 580) ~[elasticsearch-0.19.1.jar:na]  
> at  
> org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:  
> 444) ~[elasticsearch-0.19.1.jar:na]
> 
> This is the ISO datetime format as suggested by Shay. What am I  
> missing here?
> 
> Thanks!

---

<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:** [July 6, 2017, 3:29am UTC](https://discuss.elastic.co/t/es-unable-to-parse-isodatetimeformat/7577/4 "2017-07-06T03:29:49Z")

</div>