Trunc(sysdate) in SQL Server

Question

What is the equivalent of:

TRUNC(SYSDATE)

...in SQL Server 2005?

Answer 1

Use:

CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)