Subtract 24hrs in T-SQL from Today's Date

Question

I'm looking for a way to Subtract 24hrs in T-SQL from Today's Date

Thanks!

Answer 1

 SELECT GETDATE() - 1

The -1 substracts one day from current date (GETDATE())

Answer 2

DECLARE @Now datetime, @Calc datetime

SET @Now = GetDate()
SET @Calc = DateAdd(hh, -24, @Now)