# Timestamp in document is different from shown in kibana

**URL:** <https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466>\
**Category:** Elasticsearch\
**Created:** [June 14, 2024, 7:33am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466 "2024-06-14T07:33:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gbL2k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbl2k/32/130975_2.png) [@gbL2k](https://discuss.elastic.co/u/gbL2k)\
**Post date:** [June 14, 2024, 7:33am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/1 "2024-06-14T07:33:54Z")

</div>

Hello everyone!

I bet its something really basic but I dont want to waste any more time by trying to find the solution myself.  
My issue is that in kibana the timestamp is correct and shows the correct time however in the elasticsearch document the timestamp is 2 hours behind.  
Where the problem could be?I set the timezone in kibana and elasticsearch too.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 14, 2024, 8:07am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/2 "2024-06-14T08:07:17Z")

</div>

When Kibana shows standard timestamps it by default adjusts for the local timezone of the browser. All timestamps in Elasticsearch are in UTC time, so I guess you are in a timezone 2 hours off UTC?

---

<div class="post-metadata">

**Author:** ![gbL2k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbl2k/32/130975_2.png) [@gbL2k](https://discuss.elastic.co/u/gbL2k)\
**Post date:** [June 14, 2024, 8:42am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/3 "2024-06-14T08:42:52Z")

</div>

Yeah I read about this and no I checked the browser and it is in the correct timezone and also as I said the browser and kibana shows me the correct time the 2 hours difference is in the elastic document.If I look at the json object of the document the correct time is not even included in the document itself(only the wrong timestamp with the -2 hours difference is included).The time is also correct on the host where the logs are coming from.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 14, 2024, 8:46am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/4 "2024-06-14T08:46:34Z")

</div>

What is the timestamp you are seeing in Kibana? What is the timestamp in the JSON document? Which timezone are you in?

---

<div class="post-metadata">

**Author:** ![gbL2k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbl2k/32/130975_2.png) [@gbL2k](https://discuss.elastic.co/u/gbL2k)\
**Post date:** [June 14, 2024, 9:03am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/5 "2024-06-14T09:03:51Z")

</div>

I'm in GMT+2.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/2/322b092b9f9651fbd5fdeda6277c2defdcba84dd.png)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/d/ed57e6c450589b97132a694bbe2e8a2525f478c7.png)

---

<div class="post-metadata">

**Author:** ![gbL2k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbl2k/32/130975_2.png) [@gbL2k](https://discuss.elastic.co/u/gbL2k)\
**Post date:** [June 14, 2024, 9:06am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/6 "2024-06-14T09:06:29Z")

</div>

Oh I think is just realised what yous answer meant in the first reply.  
Is there a way to modify this behaviour(all timestamps are utc by default)?  
My goal is to export the logs with logstash and timestamp is a bit off.  
Should I manipulate that field after exporting the data?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 14, 2024, 11:22am UTC](https://discuss.elastic.co/t/timestamp-in-document-is-different-from-shown-in-kibana/361466/7 "2024-06-14T11:22:20Z")

</div>

All timestamps in Elasticsearch must be UTC. There is no way to change that.

> [@gbL2k](#):
>
> Should I manipulate that field after exporting the data?

If you need it in local timezone you will need to convert it from UTC once you have extracted it.
