# ES|QL dashboard table visualization displays time fields in UTC time zone

**URL:** <https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245>\
**Category:** Kibana\
**Tags:** visualisation, esql\
**Created:** [September 26, 2025, 9:11am UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245 "2025-09-26T09:11:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![allatrue](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/allatrue/32/130067_2.png) [@allatrue](https://discuss.elastic.co/u/allatrue)\
**Post date:** [September 26, 2025, 9:11am UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245/1 "2025-09-26T09:11:32Z")

</div>

Hello everyone,

is there a way to make ES|QL visualization to display time fields in local time zone, like Lens it does?

Discover converts times automatically to local time, as well as Lens dashboard visualizations. But ES|QL table visualization - doesn’t.

ES|QL also doesn’t provide any time zone conversion functions.

I use stack version 9.1.3

Regards

Alexander

---

<div class="post-metadata">

**Author:** ![Tortoise](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tortoise/32/147587_2.png) [@Tortoise](https://discuss.elastic.co/u/Tortoise)\
**Post date:** [September 28, 2025, 7:07am UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245/2 "2025-09-28T07:07:49Z")

</div>

Hello @allatrue

Could you please share an example , as with below using ES|QL i do not see any issue :

> **Queries**
>
> ```auto
> POST demo-timezone/_bulk
> {"index":{}}
> {"@timestamp": "2025-09-07T00:00:00Z", "message": "Midnight UTC"}
> {"index":{}}
> {"@timestamp": "2025-09-07T06:00:00Z", "message": "Morning UTC"}
> {"index":{}}
> {"@timestamp": "2025-09-07T12:00:00Z", "message": "Noon UTC"}
> {"index":{}}
> {"@timestamp": "2025-09-07T18:00:00Z", "message": "Evening UTC"}
> {"index":{}}
> {"@timestamp": "2025-09-07T23:59:59Z", "message": "End of Day UTC"}
> 
> While using ES|QL , i can see the date in local timezone & not UTC as shown in below screenshot : 
> 
> FROM demo-timezone
> | KEEP message, @timestamp
> | SORT @timestamp ASC
> 
> ```
> 
> ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/d/2dc2bfef98b9e24fec4677f9b72e51235cde890d.png)
> 
> Used same in Dashboard
> 
> ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/7/d750b3bfd634e0ff2b93405c2dca0bd3c30633ea.png)

Thanks!!

---

<div class="post-metadata">

**Author:** ![allatrue](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/allatrue/32/130067_2.png) [@allatrue](https://discuss.elastic.co/u/allatrue)\
**Post date:** [September 29, 2025, 6:24am UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245/3 "2025-09-29T06:24:27Z")

</div>

Dear @Tortoise ,

maybe I was not precise enough. I didn’t mean the discovery table, which works correctly, but the ES|QL dashboard table visualization:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/e/8e6ff1de9544e4754192eddca5347b4fd4dae85b.png)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/0/10a9849da99385b15c16d81632f2b93963091740.png)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/d/ad4ee1f4eebb875dfc99c3350f32948c86d09569.png)

As a workaround I can use a discovery table, but for my use case I need cell coloring features, which are not available with discovery table.

Regards

Alexander

---

<div class="post-metadata">

**Author:** ![Tortoise](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tortoise/32/147587_2.png) [@Tortoise](https://discuss.elastic.co/u/Tortoise)\
**Post date:** [September 29, 2025, 8:59am UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245/4 "2025-09-29T08:59:23Z")

</div>

Thanks @allatrue for the details.  
Yes, you are right this way it seems to be an issue & it shows the time in UTC via ES|QL

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/6/b6da4e6148790c9bfa3b152cc524c5225b1eef3e.png)

Thanks!!

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [October 23, 2025, 11:07am UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245/5 "2025-10-23T11:07:55Z")

</div>

yeah ES|QL is not supporting timezone yet. But it is on the roadmap, hopefully we will have something soon

---

<div class="post-metadata">

**Author:** ![allatrue](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/allatrue/32/130067_2.png) [@allatrue](https://discuss.elastic.co/u/allatrue)\
**Post date:** [November 25, 2025, 2:00pm UTC](https://discuss.elastic.co/t/es-ql-dashboard-table-visualization-displays-time-fields-in-utc-time-zone/382245/6 "2025-11-25T14:00:30Z")

</div>

Thanks @Stratoula_Kalafateli for information, but is this issue really about time zone support in ES|QL?

Isn’t it just a “Table visualization” issue? Other visualizations convert time fields to local time zone automatically. ES|QL dashboard table visualization could do the same, or I’m wrong?

Regards,

Alexander