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

Elastic Stack Kibana
,
1

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

1 Like
2

Hello @allatrue

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

Queries 
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
image1320×439 35.9 KB

Used same in Dashboard

image
image1365×432 29.1 KB

Thanks!!

3

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
image299×305 10.5 KB

image
image533×562 40.1 KB

image
image460×194 13 KB

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

1 Like
4

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
image1411×256 19.4 KB

Thanks!!

5

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

3 Likes
6

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