How to parse dd MMM HH:mm:ss IST date format?


(Vikas Gopal) #1

Hi Experts,

I have date value like
15 May 2017 11:52:59 IST
Here I am not sure how to handle IST
Please suggest in Logstash what date format I can apply on this value .
I used
date {match => ["endTime","dd MMM YYYY HH:mm:ss","ISO8601"] target => "endTime"}
OR
date {match => ["endTime","dd MMM YYYY HH:mm:ss Z"] target => "endTime"}

It did not work for me .

Regards
VG


(Magnus B├Ąck) #2

The date filter can't parse timezone names. Two options:

  • If the timestamp is always IST, hardcode a suitable timezone in the date filter's timezone option and use dd MMM yyyy HH:mm:ss 'IST' is your date filter pattern.
  • If the timezone can vary, extract it into a field and feed it through a translate filter to transform it into a UTC offset that the date filter can parse.

(system) #3

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