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?

Your question is confusing because you first stated that you want to remove the time part entirely (as shown in your code example), but then you indicated that you want "at midnight", which is a time part. — SendETHToThisAddress, May 11 '21 at 20:26

score 24 · Accepted Answer · answered Oct 31 '20 at 13:00

24

Use the startofday() function:

startofday( now() )

or the bin() function:

bin( now(), 1d )

answered Oct 31 '20 at 13:00

Rory

1 Answers1