How to remove time part from a datetime in Kusto

Question

If I've got a Kusto datetime and I want to remove the time portion, leaving just a date at midnight, what's the best way? I can do this

todatetime(format_datetime( now(), "yyyy-MM-dd"))

but surely there's a more efficient way?

Rory_8479 · Answer

Use the startofday() function:

startofday( now() )

or the bin() function:

bin( now(), 1d )