Hello, I have an SQLite database where new data is written every second. Currently, I am using Logstash and its JDBC plugin to read the data in real-time and ship it to Elasticsearch for visualization. Everything is working great, except for one strange issue. One of the columns in this SQLite data…

I do not see any difference between the [time] values in logstash and SQL. The code assumes your database times are in the local timezone and logstash stores everything as UTC. That's why 4 hours get added. If the [time] field in the DB includes a time I would expect that to end up in the LogStash…

(Issue) Logstash JDBC Input Plugin seems to be changing datetime column value's at output

Elastic Stack Logstash

system (system) Closed December 2, 2021, 3:21am 6

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

Topic		Replies	Views
Logstash output incorrect time value Logstash	1	316	July 11, 2019
Logstash jdbc input timestamp parse issue Logstash	5	1144	July 25, 2017
Problem with logstash jdbc input plugin. Date field data is incorrect Logstash	5	728	December 19, 2018
Converting varchar to datetime in logstash jdbc input? Logstash	1	920	December 7, 2016
Datetime from sql to Timestamp logstash Logstash	25	12006	March 7, 2018

(Issue) Logstash JDBC Input Plugin seems to be changing datetime column value's at output

Related topics