# Timestamp entries in cet without time zone are displayed in Kibana as cet +1

**URL:** https://discuss.elastic.co/t/timestamp-entries-in-cet-without-time-zone-are-displayed-in-kibana-as-cet-1/292571
**Category:** Kibana
**Created:** [December 21, 2021, 2:06pm UTC](https://discuss.elastic.co/t/timestamp-entries-in-cet-without-time-zone-are-displayed-in-kibana-as-cet-1/292571 "2021-12-21T14:06:38Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jstricker](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jstricker](https://discuss.elastic.co/u/jstricker)
#### Post date: [December 21, 2021, 2:06pm UTC](https://discuss.elastic.co/t/timestamp-entries-in-cet-without-time-zone-are-displayed-in-kibana-as-cet-1/292571/1 "2021-12-21T14:06:39Z")

</div>

I have several log files with different timestamp formats. A log file like this:

 ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/f/6/f6627e0bbd25686df00d6de4d75160aa957255ab.png)

In the other file like this:

![grafik](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d16c76b983f9ad17c3b6499aecdbba8dd4a8608c.png)

The timestampe entrys with and with out timezone specification.

With the following component template i format the timestampe.

![grafik](https://us1.discourse-cdn.com/elastic/original/3X/b/e/be6d5f630fb4d7215d8557011c99f999c27a01e9.png)

The logentry with the timezone in the timestamp are displayd correctly.

![grafik](https://us1.discourse-cdn.com/elastic/original/3X/7/3/73a588cd599e4762a2e41b6163d2200f46f97c10.png)

But the logentry without the timezone are displyed one hour off

![grafik](https://us1.discourse-cdn.com/elastic/original/3X/a/4/a461272d27156c47e061c2c4bf08b21a4ca3a9c4.png)

In kibana i have the following settings:

 ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/7/c/7c857735f1b737751a69335f5048ed046117f901.png)

What should i have to do that the timestamp without the timezone are displayed corrrectly?

---

<div class="post-metadata">

### Author: ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)
#### Post date: [December 21, 2021, 2:54pm UTC](https://discuss.elastic.co/t/timestamp-entries-in-cet-without-time-zone-are-displayed-in-kibana-as-cet-1/292571/2 "2021-12-21T14:54:24Z")

</div>

Internally dates are stored in UTC. When date format contains a timezone Elasticsearch uses it to convert to UTC, but without a timezone it just assumes UTC.

I think you'll have to convert to a UTC timezone or specify your timezone during ingestion, as it won't be possible to fix on index mapping level.

Regarding Kibana advanced setting: this is just a UI formatting configuration. With it you can specify how you want to display dates in Kibana that are stored in UTC in Elasticsearch

---

<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: [January 18, 2022, 2:54pm UTC](https://discuss.elastic.co/t/timestamp-entries-in-cet-without-time-zone-are-displayed-in-kibana-as-cet-1/292571/3 "2022-01-18T14:54:46Z")

</div>

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