KQL query - Relatively select data for today in where clause

Question

I need a way to select dataset "since midnight" in Azure Monitor - e.g relative to current day.

Using ago(1d) is obviously not doing the trick :)

StorageBlobLogs
    | where TimeGenerated > ago(1d) and StatusText contains "success"

Cheers

Answer 1

You could try using startofday().

For example: ... | where TimeGenerated > startofday(now())