Azure Data Explorer setting to display datetime values in local timezone
Can Azure Data Explorer support displaying datetime values in local timezone with a setting?
I'm a bit tired of extending all queries by doing time arithmetic myself (e.g. | extend localT = timestamp - 8h) which is not daylight saving proof as well :)
This featured is planned to be delivered within the next month or so.
Please use the feedback option in Azure Data Explorer web UI to let us know what you think of it.
This will be very useful. Please implement this feature.
This is much needed feature!
Thomas Hahn commented
I support this idea. In addition it would be great if the timezone awareness would also extend to the aggregate function and also consider daylight saving times. In our use cases all timestamps in ADX are in UTC, so the timezone could be a parameter alongside the query.