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	691	December 19, 2018
Logstash date parse failure for jdbc input Logstash	5	1541	August 10, 2017
Why am I getting _dateparsefailure in Logstash? Logstash	11	3306	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	421	July 6, 2017