# Does not take the timezone of dateFormat: tz in kibana

**URL:** https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393
**Category:** Kibana
**Created:** [October 29, 2018, 7:22am UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393 "2018-10-29T07:22:01Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Diego\_Nogueira1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_nogueira1/32/29309_2.png) [@Diego\_Nogueira1](https://discuss.elastic.co/u/Diego_Nogueira1)
#### Post date: [October 29, 2018, 7:22am UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/1 "2018-10-29T07:22:01Z")

</div>

Hello everyone,  
I am having a problem in the axes of my timelion since the timezone of Brazil was changed, I have already adjusted the global configuration in kibana and resolved to the discovery, but for the timelion no, it always stays one hour ahead. Could someone please help me? thankful.

![30](https://us1.discourse-cdn.com/elastic/original/3X/1/8/186a65ef2207fc999d4cd140cb53300ba16e518a.png)

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [October 30, 2018, 3:30pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/2 "2018-10-30T15:30:52Z")

</div>

Hey @Diego_Nogueira1, what version of Kibana are you using? Also, would you mind sharing your Timelion query?

---

<div class="post-metadata">

### Author: ![Diego\_Nogueira1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_nogueira1/32/29309_2.png) [@Diego\_Nogueira1](https://discuss.elastic.co/u/Diego_Nogueira1)
#### Post date: [October 30, 2018, 6:20pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/3 "2018-10-30T18:20:08Z")

</div>

@Brandon_Kobel, Tks for reply.

My kibana Version: 6.4.2

My Query:

.es(_exists_:service).if(eq, 0, null, .es(index=data-channels-_, q="service:M2B", timefield=@timestamp, metric=sum:busy)).fit(average).label('Ocupado').lines(fill=3,width=0.9).title('Utilização de canais / 5min - M2B').color(#89CFF0).legend(columns=2, position=sw,showTime=false), .es(exists:service).if(eq, 0, null, .es(index=data-channels-_, q="service:M2B", timefield=@timestamp, metric=sum:busy)).label(null).points(symbol=circle,fill=10,radius=1).color(blue), .static(180, label='Capacidade').color(red)

Best & Regards.

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [October 30, 2018, 7:16pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/4 "2018-10-30T19:16:23Z")

</div>

Hey @Diego_Nogueira1, I'm having trouble replicating what you're seeing with 6.4.2. Would you mind seeing if you're experiencing this same issue with this timelion query: `.es(index=data-channels-, q="service:M2B", timefield=@timestamp, metric=sum:busy)`

Also, are you using the `Auto` date interval, or are you using a specific interval? Also, what time range are you using?

---

<div class="post-metadata">

### Author: ![Diego\_Nogueira1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_nogueira1/32/29309_2.png) [@Diego\_Nogueira1](https://discuss.elastic.co/u/Diego_Nogueira1)
#### Post date: [October 31, 2018, 2:42pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/5 "2018-10-31T14:42:43Z")

</div>

> [@Brandon\_Kobel](#):
>
> .es(index=data-channels-, q="service:M2B", timefield=@timestamp, metric=sum:busy)

@Brandon_Kobel,

I have replicated the query you sent but the same problem occurs, only data appears when I change to "4 hours ago".

I also noticed that the discovery has the same problem, contrary to what I said, whenever I enter "15 minutes ago" or "1 hour ago" no data is presented, Both machine and jvm timezone are ok.

![11](https://us1.discourse-cdn.com/elastic/original/3X/d/8/d87ce434d32bf7b2be4470ddca8c0e7fbbe204cb.png)

 ![54](https://us1.discourse-cdn.com/elastic/original/3X/6/3/63bdc5fc7511c76de39fb34a43260db4cff6807e.png)

 ![1h](https://us1.discourse-cdn.com/elastic/original/3X/b/8/b84ee37b5b71e1ac1fb744979a476c6c1785a0b3.png)

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

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [October 31, 2018, 2:57pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/6 "2018-10-31T14:57:32Z")

</div>

Is it just the "Last 4 Hours" option that is causing this? Also, would you mind seeing if you have the same issue when creating a non-Timelion vertical bar chart using the date histogram aggregation?

---

<div class="post-metadata">

### Author: ![Diego\_Nogueira1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_nogueira1/32/29309_2.png) [@Diego\_Nogueira1](https://discuss.elastic.co/u/Diego_Nogueira1)
#### Post date: [October 31, 2018, 3:24pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/7 "2018-10-31T15:24:18Z")

</div>

> [@Brandon\_Kobel](#):
>
> Is it just the "Last 4 Hours" option that is causing this? Also, would you mind seeing if you have the same issue when creating a non-Timelion vertical bar chart using the date histogram aggregation?

@Brandon_Kobel,

No problem, I'll check what you asked for!

Do you take this time zone from the local machine? Is there any file? I can suddenly do a test by changing the kibana's timezone file.

I'll arrange what you asked for and then return.

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [November 2, 2018, 1:38pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/8 "2018-11-02T13:38:12Z")

</div>

@Diego_Nogueira1, Kibana's server and the client (with the default Browser) setting use your system timezone.

---

<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 30, 2018, 1:38pm UTC](https://discuss.elastic.co/t/does-not-take-the-timezone-of-dateformat-tz-in-kibana/154393/9 "2018-11-30T13:38:21Z")

</div>

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