# Hour(-5:30 minutes) in all date are getting changed

**URL:** <https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827>\
**Category:** Logstash\
**Created:** [November 21, 2019, 8:13am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827 "2019-11-21T08:13:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krishnapriya\_Mahajan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krishnapriya_mahajan/32/58029_2.png) [@Krishnapriya\_Mahajan](https://discuss.elastic.co/u/Krishnapriya_Mahajan)\
**Post date:** [November 21, 2019, 8:13am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827/1 "2019-11-21T08:13:05Z")

</div>

Hi I am trying to migrate data from mysql to ELastic Search. But in es time is getting changed.  
in mysql (2017-07-20 16:42:07) to (2017-07-20T11:12:07.000Z) in es .  
following is my logstash.conf

input {  
jdbc {  
-- jdbc connection details --  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
statement =\> "SELECT \* FROM table"  
jdbc\_paging\_enabled =\> true  
jdbc\_page\_size =\> 5000  
jdbc\_default\_timezone =\> "Asia/Kolkata"  
}  
}  
filter {  
date {  
locale =\> "en"  
timezone =\> "Asia/Kolkata"  
match =\> ["created\_at","yyyy-MM-dd'T'HH:mm:ssZ","ISO8601"]  
target =\> "created\_at"  
}  
}  
output {  
stdout { codec =\> json\_lines }  
elasticsearch {  
"hosts" =\> ["aa.bb.cc.dd:9200"]  
"index" =\> "xyzz"  
"document\_type" =\> "\_doc"  
"document\_id" =\> "%{id}"  
}  
}

PS there are multiple date filed in same table. How to specify time zone at table level instead of per field.

---

<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:** [November 21, 2019, 8:15am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827/2 "2019-11-21T08:15:43Z")

</div>

All time stamps in Elasticsearch are stored in UTC timezone so it is that conversion you are seeing.

---

<div class="post-metadata">

**Author:** ![Krishnapriya\_Mahajan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krishnapriya_mahajan/32/58029_2.png) [@Krishnapriya\_Mahajan](https://discuss.elastic.co/u/Krishnapriya_Mahajan)\
**Post date:** [November 21, 2019, 8:17am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827/3 "2019-11-21T08:17:04Z")

</div>

Yes, is there any way to have filed as date type and save it as it is. without zone difference.?

---

<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:** [November 21, 2019, 8:19am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827/4 "2019-11-21T08:19:14Z")

</div>

Timestamps must be in UTC in Elasticsearch as Kibana and some APIs assume this. You can however specify timezone when querying and have Elasticsearch translate/convert it for you.

---

<div class="post-metadata">

**Author:** ![Krishnapriya\_Mahajan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krishnapriya_mahajan/32/58029_2.png) [@Krishnapriya\_Mahajan](https://discuss.elastic.co/u/Krishnapriya_Mahajan)\
**Post date:** [November 21, 2019, 8:31am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827/5 "2019-11-21T08:31:00Z")

</div>

I guess We can specify timezone only when querying in range. I wanted correct date even when querying other field.

---

<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:** [December 19, 2019, 8:31am UTC](https://discuss.elastic.co/t/hour-5-30-minutes-in-all-date-are-getting-changed/208827/6 "2019-12-19T08:31:14Z")

</div>

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