hi i am pumping data in to ES in local timezone
in log stash i am specifying time zone
date {
match => [ "documentdate", "ISO8601","YYYY-MM-dd HH:mm:ss:SSS", "YYYY-MM-dd HH:mm:ss","YYYY-MM-dd HH:mm" ]
target => "documentdate"
locale => "en"
timezone => "Asia/Kolkata"
}
and kibana show the exact time which i am sending
but if i query ES its converting my date to UTC
why ES not storing the value as i sending ?
because of this my painless script
doc['documentdate'].value.hourOfDay
giving 18 instead of 23 .
how can i solve .
thanks