Logstash converting date / Time in correctly

When I am importing data to logstash it does not handle the data/Time correctly

It shows time Dec 2, 2019 @ 21:09:29.000

when it should show 2019/12/03 05:09:29

Message in Kibana

tmessage 2019/12/03 05:09:29,95,MP Member Policies,200,OK,View Current Policy 7-1,true,5556,1,23,https://Statements=true-GetSisDetails=true-PolicyType=,94,SERVERNAME,0,14

Raw Data

2019/12/03 05:09:29,95,MP Member Policies,200,OK,View Current Policy 7-1,true,5556,1,23,https://Statements=true-GetSisDetails=true-PolicyType=,94,SERVERNAME,0,14

filter {
csv {
columns => ["time","elapsed","label","responseCode","responseMessage","threadName","success","bytes","grpThreads","allThreads","url","latency","Hostname","IdleTime","Connect"]
}

#Logstash date config section

date {
match => ["time","yyyy/MM/dd HH:mm:ss"]
target => "time"
}

Can any one help with this?

logstash and elasticsearch store times in the UTC timezone. kibana will, by default, convert them to the browsers local timezone. If your logs are not in your local timezone you can use the timezone option on the date filter to tell it what timezone they are in.

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