Date format, how to change it?

[Mbt_Mbt]

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

[Badger]

@Mbt_Mbt

date { match => ["charged", "yyyy-MM-dd HH:mm:ss", "ISO8601"]

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" ] }

[Mbt_Mbt]

Thanks for your help,

it didnt worked,

The initial format is string with the following form

execEndTime:

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:

execEndTime:

Feb 14, 2020 @ 09:19:45.060

I need to visulize with the format:

2020-14-02T09:19:45.060Z

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

Many thanks

[Badger]

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