Hello, I'm trying to read input from JDBC and applied date filter but logstash logs is one hour ahead the actual date. I don't where this difference came from. Logstash conf file input { jdbc { jdbc_driver_library => "DDD" jdbc_driver_class => "com.mysql.jdbc.Driver" jdbc_connection_string => "DDD…

Logstash timestamp issue - the log line date is one hour ahead the actual date

Badger August 9, 2020, 12:22pm 2

Does this post help? Your date filter does not set the timezone, so it will be assuming that what came out of the database is UTC.

Topic		Replies	Views
Problem with logstash jdbc input plugin. Date field data is incorrect Logstash	5	692	December 19, 2018
Why am I getting _dateparsefailure in Logstash? Logstash	11	3311	July 17, 2018
Datetime coming wrongly in logstash Logstash	2	342	April 27, 2017
@timestamp always 8h exact more than the matching time? Logstash	3	422	July 6, 2017
(Issue) Logstash JDBC Input Plugin seems to be changing datetime column value's at output Logstash jdbc	5	1193	December 2, 2021