# Logstatsh Time Zone issue

**URL:** <https://discuss.elastic.co/t/logstatsh-time-zone-issue/297280>\
**Category:** Logstash\
**Created:** [February 15, 2022, 5:48pm UTC](https://discuss.elastic.co/t/logstatsh-time-zone-issue/297280 "2022-02-15T17:48:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hanumant](https://avatars.discourse-cdn.com/v4/letter/h/3ec8ea/32.png) [@hanumant](https://discuss.elastic.co/u/hanumant)\
**Post date:** [February 15, 2022, 5:48pm UTC](https://discuss.elastic.co/t/logstatsh-time-zone-issue/297280/1 "2022-02-15T17:48:35Z")

</div>

Hi Team,  
environment logstatsh and elastic server are running in IST System DataBase is in UTC time zone  
I'm using JDBC logstatsh to push the information I'm seeing the date related all columns values are getting altered  
Example: dob Column is having only date information but logstatsh adding time in the values and its adding -5.30 value in that DateTime  
created date values in the database and values in the Elasticsearch is having -5.30 hours difference

DOB: DB Value 1994-06-22 value in Elasticsearch engine is 1994-06-22T18:30:00Z  
CreatedDate :2022-02-15 07:55:27.463 value in Elasticsearch engine is 2022-02-15T02:14:41.140Z

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [February 15, 2022, 5:55pm UTC](https://discuss.elastic.co/t/logstatsh-time-zone-issue/297280/2 "2022-02-15T17:55:39Z")

</div>

The jdbc filter automatically transforms date/time columns in a database into LogStash::Timestamp objects, these include a time in UTC. So if the column just contains a date it will get offset according to the timezone.

Possible solutions [here](https://discuss.elastic.co/t/stuck-with-timezone-issue-in-logstash-jdbc-input/236707/4).

---

<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:** [March 15, 2022, 5:56pm UTC](https://discuss.elastic.co/t/logstatsh-time-zone-issue/297280/3 "2022-03-15T17:56:29Z")

</div>

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