# Date with time is populated wrongly in index

**URL:** <https://discuss.elastic.co/t/date-with-time-is-populated-wrongly-in-index/9912>\
**Category:** Elasticsearch\
**Created:** [December 1, 2012, 2:02pm UTC](https://discuss.elastic.co/t/date-with-time-is-populated-wrongly-in-index/9912 "2012-12-01T14:02:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vamsi\_Krishna](https://avatars.discourse-cdn.com/v4/letter/v/a8b319/32.png) [@Vamsi\_Krishna](https://discuss.elastic.co/u/Vamsi_Krishna)\
**Post date:** [December 1, 2012, 2:02pm UTC](https://discuss.elastic.co/t/date-with-time-is-populated-wrongly-in-index/9912/1 "2012-12-01T14:02:03Z")

</div>

Hi,

I am using "elasticsearch-river-jdbc-1.3.2.jar" file for uploading data  
from DB (postgres) to ES Index.

Problem is timestamp stored in DB is converted into GMT (timezone) format  
and stored in ES, due to this the time that indexed in ES differs from DB  
by 5:30 hours.

Example:  
DB --\> 2012-01-01 00:00:00  
ES --\> 2011-12-31T18:30:00Z

After looking into source, I understand that if the type of the column is  
timestamp then the time zone is set to GMT by default.

Please help me out.

Thanks & Regards,  
VAMSI KRISHN P

--

---

<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:** [July 6, 2017, 3:01am UTC](https://discuss.elastic.co/t/date-with-time-is-populated-wrongly-in-index/9912/2 "2017-07-06T03:01:53Z")

</div>