Hi,
I am using ELK GA 6.3.0. I have the logstash configuration like below;
input {
jdbc {
jdbc_driver_library => "ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@127.0.0.1:1521:adminsid"
jdbc_user => "user"
jdbc_password => "pa$$word"
statement => "SELECT START_TIME as timefield1, to_char(START_TIME, 'YYYY-MM-DD HH24:MI:SS:FF3') as timefield2 FROM mytable WHERE rownum <= 1"
}
}
output {
stdout {
codec => rubydebug {
metadata => true
}
}
}
I am getting the output as;
{
"timefield1" => 2018 - 10 - 22T00: 55: 39.587Z,
"@version" => "1",
"timefield2" => "2018-10-22 06:25:39:587",
"@timestamp" => 2018 - 11 - 21T09: 42: 23.204Z,
}
Everything except hour and minute are same. Why is there a difference in hour and minute, and how to fix this?
Thanks.