Date format, how to change it?

Hello good afternoon,

I am trying to change the way of displaying date type data but I am not able.

Can someone help me on how to visualize the dates with the format: 2020-13-02T10:01:01.000Z

Currently the field has the format, charged: Feb 13, 2020 @ 17:54:24.870

My filter looks that:

date { match => ["charged", "yyyy-MM-dd HH:mm:ss", "ISO8601"]
timezone => "Etc/GMT+1"
target => "charged"

Many thanks

The format in the date filter has to match the format of the field. Try

date { match => [ "charged", "MMM dd, yyyy '@' HH:mm:ss.SSS" ] }

Thanks for your help,

it didnt worked,

The initial format is string with the following form


2020-02-14 08:19:45.060

After applying the pugling date, we transform the data to date type

date { match => ["execEndTime", "yyyy-MM-dd HH:mm:ss", "ISO8601"]
timezone => "Etc/GMT+1"
target => "execEndTime"

The result obtained in Kibana is:


Feb 14, 2020 @ 09:19:45.060

I need to visulize with the format:


Is there any way to have that information with the latest format?

Many thanks

You want to change the format that the presentation layer uses? Or you want to parse the date?

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