# Logstash sql\_last\_value to eastern timestamp
**URL:** https://discuss.elastic.co/t/logstash-sql-last-value-to-eastern-timestamp/99758
**Category:** Logstash
**Created:** [September 7, 2017, 6:55pm UTC](https://discuss.elastic.co/t/logstash-sql-last-value-to-eastern-timestamp/99758 "2017-09-07T18:55:33Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@swaplogstash](https://discuss.elastic.co/u/swaplogstash)
#### Post date: [September 7, 2017, 6:55pm UTC](https://discuss.elastic.co/t/logstash-sql-last-value-to-eastern-timestamp/99758/1 "2017-09-07T18:55:33Z")
Our database has date field with datatype as TIMESTAMP and its eastern time (ex:05-SEP-17 10.00.00.209000000 AM)
and logstash sql\_last\_value has UTC(ex: 2017-09-07 18:40:00.205000000 Z). How can we convert sql\_last\_value to
eastern time for comparison in jdbc plugin ? Is there a way to customize logstash to use local timezone(eastern)
so that we dont need to typecast in SQL query.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 5, 2017, 6:56pm UTC](https://discuss.elastic.co/t/logstash-sql-last-value-to-eastern-timestamp/99758/2 "2017-10-05T18:56:12Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.