# Why value table and json is different in kibana?

**URL:** <https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647>\
**Category:** Kibana\
**Created:** [September 25, 2017, 7:05am UTC](https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647 "2017-09-25T07:05:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ibnuali](https://avatars.discourse-cdn.com/v4/letter/i/e495f1/32.png) [@ibnuali](https://discuss.elastic.co/u/ibnuali)\
**Post date:** [September 25, 2017, 7:05am UTC](https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647/1 "2017-09-25T07:05:03Z")

</div>

when i post a datetime value, kibana table not same with json format

it is format table

 ![Screenshot from 2017-09-25 14-00-49](https://us1.discourse-cdn.com/elastic/original/3X/f/d/fdc1e0080793a68fc9a72429f837af5b6a2e014d.png)

it is format json

 ![Screenshot from 2017-09-25 14-00-59](https://us1.discourse-cdn.com/elastic/original/3X/0/b/0be367939b5577ee978b10b159685fd251e17d0b.png)

---

<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:** [September 25, 2017, 7:18am UTC](https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647/2 "2017-09-25T07:18:39Z")

</div>

I believe this is because the JSON document shows the timestamp in UTC timezone (which is what is indexed into Elasticsearch), while Kibana is able to change this into local time based on the browser timezone in the table view.

---

<div class="post-metadata">

**Author:** ![ibnuali](https://avatars.discourse-cdn.com/v4/letter/i/e495f1/32.png) [@ibnuali](https://discuss.elastic.co/u/ibnuali)\
**Post date:** [September 25, 2017, 7:36am UTC](https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647/3 "2017-09-25T07:36:24Z")

</div>

i see. how to change kibana date format to same like my regional (UTC +7)

---

<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:** [September 25, 2017, 7:48am UTC](https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647/4 "2017-09-25T07:48:12Z")

</div>

Apart from the raw documents, which is what you see in the JSON view, Kibana should adjust timestamps to local timezone elsewhere. Timestamps in Elasticsearch has to be in UTC, so changing the timestamp in the JSON is not really possible.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 23, 2017, 7:48am UTC](https://discuss.elastic.co/t/why-value-table-and-json-is-different-in-kibana/101647/5 "2017-10-23T07:48:35Z")

</div>

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