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