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

[allatrue (Alexander)]

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

[Tortoise]

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

Used same in Dashboard

Thanks!!

[allatrue (Alexander)]

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:

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

[Tortoise]

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

Thanks!!