Get yesterday's date in T-SQL.

I am stealing from here...

select dateadd(dd,-1, cast(getdate() as date))