What’s the best way to truncate a datetime value (as to remove hours minutes and seconds) in SQL Server 2008?
For example:
declare @SomeDate datetime="2009-05-28 16:30:22"
select trunc_date(@SomeDate)
-----------------------
2009-05-28 00:00:00.000