What’s a good way to check if two datetimes are on the same calendar day in TSQL?

September 4, 2023 by Tarik

This is much more concise:

where 
  datediff(day, date1, date2) = 0