[excel] I have these 2 cells the first is Day which was converted fine using the date filter but the HOUR column is appearing as a random date time stamp with no hours my logstash date config: date { match => ["DAY", "M/d/yyyy", "M/dd/yyyy", "MM/d/yyyy", "MM/dd/yyyy"] target => "DAY" locale => …

Convert a column in csv to hour time

Badger January 7, 2019, 9:38pm 2

ruby { code => 'event.set("HOUR", LogStash::Timestamp.new(event.get("DAY")+ 3600 * event.get("HOUR")))' }

Error handling is left as an exercise for the reader.

Logstash deal with 24:00 time representation

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.