Logstash Date and Kibana Issues

[Aaron_Caldwell]

Hello,

I do think this belongs in the Logstash forum so I'll move it back over, but I did find this similar issue which may help!

Kibana Timezone settings

I am using logstash 5.1 streaming mysql data to elasticsearch 5.1, kibana 5 and this is my logstash code: input { jdbc { jdbc_driver_library => "./mysql-connector-java-5.1.36.jar" jdbc_driver_class => "com.mysql.jdbc.Driver" jdbc_connection_string => "jdbc:mysql://..." jdbc_user => "myuser" jdbc_password => "mypassword" jdbc_fetch_size => 200 statement => " select * from mytable where datetime >= '2016-12-01 11:00:00' and datetime < '2016-12-01 12:00:00' limit 1"…

Regards,
Aaron