Won't the query cost for

select dbo.datefloor(getdate(),'dd')

be a lot higher than say

select convert(datetime, convert(char(10), getdate(), 120))

?