CODEWITHSUNDEEP
elasticsearchlogstashelastic-stack
gd vigneshwar
gd vigneshwar

Reputation: 867

Date filter in logstash: bad results(shows one day back)

I am loading a CSV file into elastic using logstash

This CSV file contains a column 'deadline' which has dates of the format

"deadline": "15-06-2014"

I am using the date filter plugin in logstash to get this in date format into elastic

  date {
    match => ["deadline","dd-MM-yyyy"]
    target => "deadline_date"
  }

But in the output I am receiving the date which has moved one day back

"deadline_date": "2014-06-14T18:30:00.000Z"

I have one more instance with format like this "dd-MM-yyyy HH:mm" 

date {
    match => ["launched","dd-MM-yyyy HH:mm"]
    target => "launched_date"
  }

Gives result with time changed 

"launched": "09-09-2013 18:19"

"launched_date": "2013-09-09T12:49:00.000Z"

Please help me figure out this issue.

Upvotes: 0

Views: 124

Answers (1)

Val
Val

Reputation: 217274

You're missing your timezone:

date {
  match => ["deadline","dd-MM-yyyy"]
  target => "deadline_date"
  timezone => "Etc/GMT"
}

Upvotes: 1

Related Questions