Logstash sql_last_value to eastern timestamp

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.

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