I have a table with such columns: |utcDateTime|hash|Type|tran|Code| |2019-04-19 14:53:36.000|d893b735ed52413d9b3ac2109961463f|NULL|NULL|NULL| When I filter them through logstash with jdbc {} input plugin, the first column(utcDateTime) is decreases by another 3 hours (I'm at the UTC+3). And output …

My fault. With line jdbc_default_timezone => "UTC" in input works.

Double convert timezone when parse datetime from sql

Badger April 19, 2019, 4:52pm 2

You might be able to fix it like this. Or you could add a timezone option to the date filter to force it to move the timestamp forward three hours.

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.