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 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.