# Coverting timezone to corect format

**URL:** <https://discuss.elastic.co/t/coverting-timezone-to-corect-format/151304>\
**Category:** Logstash\
**Created:** [October 6, 2018, 8:54am UTC](https://discuss.elastic.co/t/coverting-timezone-to-corect-format/151304 "2018-10-06T08:54:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![punit\_j](https://avatars.discourse-cdn.com/v4/letter/p/a87d85/32.png) [@punit\_j](https://discuss.elastic.co/u/punit_j)\
**Post date:** [October 6, 2018, 8:54am UTC](https://discuss.elastic.co/t/coverting-timezone-to-corect-format/151304/1 "2018-10-06T08:54:04Z")

</div>

Hi,

I have date from logs in below format:

2018-10-06 04:25:43 EDT

how can I convert it using date filter. I tried

date {  
match =\> { "Date", "yyyy-MM-dd HH:mm:ss ZZZ" }  
target =\> ["@timestamp"]  
}

however it produces \_dateparsefailure error

---

<div class="post-metadata">

**Author:** ![punit\_j](https://avatars.discourse-cdn.com/v4/letter/p/a87d85/32.png) [@punit\_j](https://discuss.elastic.co/u/punit_j)\
**Post date:** [October 7, 2018, 1:14am UTC](https://discuss.elastic.co/t/coverting-timezone-to-corect-format/151304/2 "2018-10-07T01:14:28Z")

</div>

Any suggestions please ?

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 9, 2018, 8:18pm UTC](https://discuss.elastic.co/t/coverting-timezone-to-corect-format/151304/3 "2018-10-09T20:18:35Z")

</div>

EDT isn't a supported timezone name. You can use a mutate filter's gsub option to replace the timezone names that you'll encounter in your logs with a UTC offset and use ZZ in the date pattern to parse it.

---

<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:** [November 6, 2018, 8:18pm UTC](https://discuss.elastic.co/t/coverting-timezone-to-corect-format/151304/4 "2018-11-06T20:18:36Z")

</div>

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