Please excuse the ignorance of my question, I'm still trying get my arms around working with elk, not my forte. I'm generating a csv for a report that contains a few columns that refer to date/time stamps. During generation I'm normalizing these fields from their original formatted state to their …

[image] karlkras: millisecond representation Do you mean milliseconds since the epoch? If so I would suggest using a date filter to match the UNIX_MS format. That will create a Timestamp object (logstash has a Timestamp data type). When a Timestamp field is sent to elasticsearch then date de…

Discuss the Elastic Stack

Date/time field formatting from csv input

Elastic Stack Logstash

karlkras March 4, 2023, 9:19pm 3

Yep, that's the format I'm talking about.
I see you answered a similar question a few years back.

Sorry, I'll work on my forum searching chops.

Regards!

Topic		Replies	Views
Logstash csv - date and file format Logstash	5	2048	March 15, 2017
Logdate field with format YYYY-MM-dd HH:mm:ss,SSS converted to 2015-01-01T00:33:33.000Z Logstash	4	3685	July 6, 2017
Problem with timestamp field Logstash	2	253	July 8, 2019
@timestamp - Epoch - Illegal Date Format exception Logstash	3	572	May 31, 2018
Date Field as "Date" Time as "Time" - Why this so hard to do in Logstash? Logstash	9	378	February 14, 2019

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.

Date/time field formatting from csv input

Related topics