# Timestamp isn't Matching from what was imported into Elasticsearch

**URL:** <https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059>\
**Category:** Kibana\
**Created:** [October 18, 2018, 6:32pm UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059 "2018-10-18T18:32:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![schoffelman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/schoffelman/32/18461_2.png) [@schoffelman](https://discuss.elastic.co/u/schoffelman)\
**Post date:** [October 18, 2018, 6:32pm UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059/1 "2018-10-18T18:32:51Z")

</div>

I imported my JSON into elasticsearch with the timestamp displaying in my `_source` not matching what is displaying in Kibana. Has anyone else ran into this?

Here's an example:

 ![Discover_-Kibana_2_png_and_Discover-Kibana_png_and_curl-XPUT_-u_elastic __https___ elastic_POHxhrIp1uh_and_Discover_-_Kibana](https://us1.discourse-cdn.com/elastic/original/3X/8/b/8bd4a1be68c15896ec0fc168711a59f4f0126126.jpeg)

---

<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:** [October 18, 2018, 6:53pm UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059/2 "2018-10-18T18:53:37Z")

</div>

All timestamps in Elasticsearch are in UTC, but Kibana will adjust this to the local timezone when displaying the data. It does however not modify the source, which should explain the discrepancy you are seeing.

---

<div class="post-metadata">

**Author:** ![schoffelman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/schoffelman/32/18461_2.png) [@schoffelman](https://discuss.elastic.co/u/schoffelman)\
**Post date:** [October 18, 2018, 8:06pm UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059/3 "2018-10-18T20:06:17Z")

</div>

Ah, gotcha. Thank you for the heads up on the difference between Elasticsearch vs Kibana.

This does throw people off when working with the data in the reports. Meaning, if we show all data for a week, Monday's info shows on Sunday. Is there a way to specify what the UTC offset is or am I better off going into Kibana's settings, adjusting the timezone from browser specific, to UTC-0? Or is there a different route altogether I should consider so that when people are looking at reports, Monday's data is displaying as Monday?

---

<div class="post-metadata">

**Author:** ![schoffelman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/schoffelman/32/18461_2.png) [@schoffelman](https://discuss.elastic.co/u/schoffelman)\
**Post date:** [October 18, 2018, 8:13pm UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059/4 "2018-10-18T20:13:45Z")

</div>

I see there's a setting in Management \> Kibana \> Advanced Settings called "Timezone for date formatting" that can be set to UTC. I changed this and it seemed to have resolved the issue.

If there's a better way to handle this let me know, otherwise, thank you again!

---

<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:** [October 19, 2018, 5:35am UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059/5 "2018-10-19T05:35:21Z")

</div>

No, that is what I was going to suggest as a workaround.

---

<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 16, 2018, 5:35am UTC](https://discuss.elastic.co/t/timestamp-isnt-matching-from-what-was-imported-into-elasticsearch/153059/6 "2018-11-16T05:35:23Z")

</div>

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