This post is the reason why I set up this blog. I always look this function up so it makes sense to be in one place!

Two versions, the first one is my favourite:

print dateadd(dd,0, datediff(dd,0,getdate()))

print convert(nvarchar(12), getdate(), 101)