# Kibana Timestamp Format

**URL:** <https://discuss.elastic.co/t/kibana-timestamp-format/110369>\
**Category:** Kibana\
**Created:** [December 5, 2017, 2:03pm UTC](https://discuss.elastic.co/t/kibana-timestamp-format/110369 "2017-12-05T14:03:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jakelaws](https://avatars.discourse-cdn.com/v4/letter/j/a698b9/32.png) [@jakelaws](https://discuss.elastic.co/u/jakelaws)\
**Post date:** [December 5, 2017, 2:03pm UTC](https://discuss.elastic.co/t/kibana-timestamp-format/110369/1 "2017-12-05T14:03:12Z")

</div>

Hi,

I am currently have NiFi ingesting data into our elastic search environment. We are trying to get elastic to recognize the timestamp format '2017-12-04 18:25:30.114000+00:00' but no matter what we have tried it fails.

I have tried loading it into a new index and seeing if selecting "Index contains time-based events", if it would have it as an option, and it did not.

I also tried pre-formatting the index with things such as:  
PUT {index}  
{  
"mappings": {  
"{typeName}": {  
"properties": {  
"{fieldName}" : {  
"type": "date",  
"format": "yyyy-MM-dd HH:mm:ss.SSSSSSZZ"  
}  
}  
}  
}  
}

also tried format: strict\_date\_optional\_time

This also did not work and then when trying to import the data into this index I would receive Illegal Argument exception, invalid format.

Please advise on how to get this timestamp format recognized.

Thank you.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [December 5, 2017, 2:22pm UTC](https://discuss.elastic.co/t/kibana-timestamp-format/110369/2 "2017-12-05T14:22:21Z")

</div>

Timestamps in Elasticsearch are limited to millisecond precision, so I wonder if that could be contributing?

---

<div class="post-metadata">

**Author:** ![jakelaws](https://avatars.discourse-cdn.com/v4/letter/j/a698b9/32.png) [@jakelaws](https://discuss.elastic.co/u/jakelaws)\
**Post date:** [December 5, 2017, 3:32pm UTC](https://discuss.elastic.co/t/kibana-timestamp-format/110369/3 "2017-12-05T15:32:17Z")

</div>

I tried changing it to "2017-12-05 15:26:04 UTC" with still no luck. Was not recognized in time based field events drop down.

I tried preformatting with

PUT rest\_services  
{  
"mappings": {  
"jmsRunTime": {  
"properties": {  
"@timestamp" : {  
"type": "date",  
"format": "yyyy-MM-dd HH:mm:ss ZZ"  
}  
}  
}  
}  
}

With still no luck. Please advise.

---

<div class="post-metadata">

**Author:** ![jakelaws](https://avatars.discourse-cdn.com/v4/letter/j/a698b9/32.png) [@jakelaws](https://discuss.elastic.co/u/jakelaws)\
**Post date:** [December 7, 2017, 12:22am UTC](https://discuss.elastic.co/t/kibana-timestamp-format/110369/4 "2017-12-07T00:22:58Z")

</div>

Any update on this?

---

<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 4, 2018, 12:23am UTC](https://discuss.elastic.co/t/kibana-timestamp-format/110369/5 "2018-01-04T00:23:13Z")

</div>

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