Time is getting change in ES

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

image

but if i query ES its converting my date to UTC
image

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

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