Hi guys, I get data from an sql server database and i have a date on a string format like this : "2017-04-25 00:00:00 +0200" and I want to use grok filter to transform this to a similar format to @timestamp I have this code grok { match => ["message","(?<log_date>%{YEAR}-%{MONTHNUM}-%{MONTHDAY}…

Extract the whole timestamp string to a separate field and use the date filter to parse it into @timestamp.

Filter a string date format on logstash

magnusbaeck (Magnus Bäck) April 28, 2017, 1:56pm 4

With date filter we can transform a string to a timestamp?

Yes, that's exactly what that filter does.

Topic		Replies	Views
Converting string to date Logstash	8	51189	July 6, 2017
Grok filter TIMESTAMP_ISO8601 appears in Kibana as String Logstash	4	2692	January 11, 2021
How to convert string type to timestamp Logstash	2	554	October 16, 2018
Filter "Date" not applying to @timestamp Logstash	3	354	May 10, 2019
My timestamp can't get converted to a date type Logstash	8	4401	June 27, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Filter a string date format on logstash

Related topics