Logstash, kibana day early date issue

Elastic Stack Logstash
1

I am loading a csv file into elasticsearch using logstash. I used the date filter plugin to convert my date column to date type in my config file :
date {
match => ["DAY", "M/d/yyyy", "M/dd/yyyy", "MM/d/yyyy", "MM/dd/yyyy"]
target => "DAY"
locale => "en"

}
every date indexed appears a day earlier then my data for example , 2018-10-2 is appearing 2018-10-1

2

All timestamps in Elasticsearch are stored in UTC timezone. The date filter will assume the dates/timestamps are in the local timezone by default (you can override this) and convert them top UTC.

3

Thank you! This solved my problem

4

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