Kibana show wrong time compared to the time value indexed in Elasticsearch


#1

I have one "date" field stored in one index correctly. I can verify it by issue command "curl -XGET 'http://localhost:9200/myindex'. However, in KIbana I always get wrong time value that is the original time + 8 hours.

For instance, I have one document with the date = 2016-01-26 11:18:10. In the Kibana, it shows as 2016-01-26 19:18:10.

Anyone can help?

Thanks


#2

BTW, my host running Elasticsearch and Kibana is set to GMT+8 for Timezone.


(Matt Bargar) #3

Are the dates you're storing in UTC or some other time zone? Elasticsearch automatically converts dates into UTC, so if your dates are in a different timezone and you're not specifying that timezone alongside the date data, Elasticsearch is going to assume the date you're giving it is UTC. When reading that date, Kibana will assume the date is UTC and do the timezone conversion to GMT+8 which would explain why it's showing the original time + 8 hours


#4

Hi Matt,

What you pointed out is the key. I added timezone info while indexing data into Elasticsearch and all work well now.

Many thanks!
Gavin


(system) #5