How to set RequestDate as the @timestamp so that I can use it in Kibana?


(Rajeev) #1

Hi ,

My logstash config file has filter as :

date { match => ["RequestDate","MM/dd/yyyy: HH:mm:ss" ]
timezone => "UTC"
}

in My input file RequestDate is having value like :12/23/2015 3:32:00 AM ,12/25/2015 7:52:00 PM etc.

I am getting error :←[33mFailed parsing date from field {:field=>"RequestDate", :value=>"12/25/2015
8:57", :exception=>"Invalid format: "12/25/2015 8:57" is malformed at " 8:57
"", :config_parsers=>"MM/dd/yyyy: HH:mm:ss", :config_locale=>"default=en_US", :l
evel=>:warn}←[0m

Kindly help me asap.


(David Pilato) #2

Moved to logstash


#3

Hi,

when using HH in the pattern it means that the hours must always use two digits like 08:57, but in your case you should a single H like this MM/dd/yyyy H:mm:ss

HTH


(system) #4