# Convert JSON formatted apache log time to datetime

**URL:** <https://discuss.elastic.co/t/convert-json-formatted-apache-log-time-to-datetime/93838>\
**Category:** Logstash\
**Created:** [July 19, 2017, 8:35pm UTC](https://discuss.elastic.co/t/convert-json-formatted-apache-log-time-to-datetime/93838 "2017-07-19T20:35:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ndhilliprasad](https://avatars.discourse-cdn.com/v4/letter/n/ac91a4/32.png) [@ndhilliprasad](https://discuss.elastic.co/u/ndhilliprasad)\
**Post date:** [July 19, 2017, 8:35pm UTC](https://discuss.elastic.co/t/convert-json-formatted-apache-log-time-to-datetime/93838/1 "2017-07-19T20:35:55Z")

</div>

Hi,

I am new to the ELK stack. We have setup a Filebeat -\> Logstash -\> Elastic -\> Kibana.

Apache logs are in JSON format (This will avoid grok filter) as following

_{ "time":"[31/May/2017:00:12:58 -0500]", "clientIP":"-", "x-forwarded-for":"a.b.c.d", "request":"/v2/test", "query":"", "method":"POST", "status":200, "userAgent":"xxxxxx", "referer":"-", "size":297, "resTime":8530, "correlationId":"dgaysudt6a7d5dhjsdgjh"}_

Now how do I get the time field from the JSON parsed as datetime into the same field.

Thanks in advance  
-Dhilli

---

<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 17, 2017, 3:43pm UTC](https://discuss.elastic.co/t/convert-json-formatted-apache-log-time-to-datetime/93838/3 "2017-08-17T15:43:20Z")

</div>

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