Logstash sql_last_value to eastern timestamp


#1

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.


(system) #2

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