Here is another alternative:
select cast((convert(char(13),getdate(),120) + ':00:00.000') as datetime)
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP