# Kibana automatically adjusting time

**URL:** <https://discuss.elastic.co/t/kibana-automatically-adjusting-time/205428>\
**Category:** Kibana\
**Created:** [October 28, 2019, 9:02am UTC](https://discuss.elastic.co/t/kibana-automatically-adjusting-time/205428 "2019-10-28T09:02:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Budi\_H](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/budi_h/32/45740_2.png) [@Budi\_H](https://discuss.elastic.co/u/Budi_H)\
**Post date:** [October 28, 2019, 9:02am UTC](https://discuss.elastic.co/t/kibana-automatically-adjusting-time/205428/1 "2019-10-28T09:02:05Z")

</div>

I have field named `datetime` and the type is date. Here's my mapping

`{ "mappings" : { "properties" : { "datetime" : { "type" : "date", "format": "dd-MM-yyyy HH:mm:ss.SSS"} } } }`

I'm in GMT+7, and Kibana always adds 7 hours to `datetime` field. For example, in elasticsearch the value of `datetime` is 21-08-2019 09:25:11.371. Kibana shows 21-08-2019 16:25:11.371 for this data.

I don't want Kibana to add 7 hours to `datetime`. How can I stop this?

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [October 28, 2019, 11:19am UTC](https://discuss.elastic.co/t/kibana-automatically-adjusting-time/205428/2 "2019-10-28T11:19:49Z")

</div>

Hi @Budi_H

The possible cause of this could be the format stored in ES: If you are sending your date already formatted in your current timezone but you don't specify the timezone in the value passed to ES, ES will think that this value is in UTC [https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html) converting it to something like `2019-08-21T09:25:11.371Z`  
If Kibana is configured with `Browser` timezone (GMT+7), then that value will be formatted as +7 hours.  
Please check if the value sent to ES are in UTC. If not you should configure your ingestion to take care of the timezone, or you can configure your mapping with a different timezone.

Please check also the value configured in the Kibana Advanced Settings under `dateFormat:tz`.

---

<div class="post-metadata">

**Author:** ![Budi\_H](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/budi_h/32/45740_2.png) [@Budi\_H](https://discuss.elastic.co/u/Budi_H)\
**Post date:** [October 29, 2019, 10:07am UTC](https://discuss.elastic.co/t/kibana-automatically-adjusting-time/205428/3 "2019-10-29T10:07:17Z")

</div>

Setting `dateFormat:tz`in Kibana to UTC solved my issues. Thanks

---

<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:** [November 26, 2019, 10:07am UTC](https://discuss.elastic.co/t/kibana-automatically-adjusting-time/205428/4 "2019-11-26T10:07:46Z")

</div>

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