# How to convert a Date field from CET timezone to UTC and save in elasticsearch using logstash

**URL:** https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286
**Category:** Logstash
**Created:** [January 11, 2017, 10:19pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286 "2017-01-11T22:19:21Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![g\_dev](https://avatars.discourse-cdn.com/v4/letter/g/91b2a8/32.png) [@g\_dev](https://discuss.elastic.co/u/g_dev)
#### Post date: [January 11, 2017, 10:19pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286/1 "2017-01-11T22:19:21Z")

</div>

I want to convert date from CET i.e. 2014-11-12T13:52:11.000Z  
I want output as UTC: 2014-11-12T11:52:11.000Z  
How can I achieve thus?  
Thanks!

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 11, 2017, 10:24pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286/2 "2017-01-11T22:24:33Z")

</div>

The date filter is what you want! 🙂  
[https://www.elastic.co/guide/en/logstash/5.1/plugins-filters-date.html](https://www.elastic.co/guide/en/logstash/5.1/plugins-filters-date.html)

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 11, 2017, 10:29pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286/4 "2017-01-11T22:29:58Z")

</div>

What does your data look like then, after the grok?

---

<div class="post-metadata">

### Author: ![g\_dev](https://avatars.discourse-cdn.com/v4/letter/g/91b2a8/32.png) [@g\_dev](https://discuss.elastic.co/u/g_dev)
#### Post date: [January 11, 2017, 10:30pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286/5 "2017-01-11T22:30:22Z")

</div>

Thanks for reply but I have already tried that, as below:  
date {  
match =\> ["validationStopTime" , "yyyy-MM-dd'T'HH:mm:ss.SSSZ"]  
target =\> "validationStopTime"  
timezone =\> "Europe/Athens"  
}

But I'm getting a exception: cannot convert instance of class org.jruby.RubyObject to class java.lang.String

---

<div class="post-metadata">

### Author: ![g\_dev](https://avatars.discourse-cdn.com/v4/letter/g/91b2a8/32.png) [@g\_dev](https://discuss.elastic.co/u/g_dev)
#### Post date: [January 11, 2017, 10:36pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286/6 "2017-01-11T22:36:28Z")

</div>

This the final output I store in elasticSearch right now : "2015-11-17T05:55:14.000Z"

---

<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: [February 8, 2017, 10:36pm UTC](https://discuss.elastic.co/t/how-to-convert-a-date-field-from-cet-timezone-to-utc-and-save-in-elasticsearch-using-logstash/71286/7 "2017-02-08T22:36:37Z")

</div>

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