application insights kusto working with dates
While working with dates are relatively easy until you be more specific. For example, what is the date and time range or between start and finish datetime range. By default, application insights uses UTC time for its query. It is often a hassle when trying to convert between UTC to local time - and often introduces error in the query How can we convert t local time? Save some time trying to figure out why there's no record coming back when we know there's some data in there. request | where timestamp between ( datetime_local_to_itc(datetime( 2026 - 10 - 0 7 11 : 00 : 00 , "Australia/Sydney" )) .. datetime_local_to_itc(datetime( 2026 - 10 - 0 7 11 : 15 : 00 , "Australia/Sydney" )) )