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!

Solution 1

 SELECT GETDATE() - 1

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

Solution 2

DECLARE @Now datetime, @Calc datetime

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

Solution 3

select dateadd(d,-1,GETDATE())

Solution 4

SELECT DATEADD(dd, -1, GETDATE()) AS yesterday

View more solutions

Comments

[marc_s]

If you post code or XML, please highlight those lines in the text editor and click on the "code" button (101 010) on the editor toolbar to nicely format and syntax highlight it!

[marc_s]

works - but seems a bit unintuitive; to me, it's not obvious right from the get go that the -1 is "-1 day" .... I'd rather be explicit (DATEADD(D, -1, GETDATE()) - makes it easier to read (for others, and for you in a year or two) and helps with maintenance...

[veljkoz]

well, if you use it all the time, than you won't forget, but in general, I have to agree with you

[Chris]

Sorry kind of new posting on this site.

[Michael B]

This subtracts 1 day. NOT 24 hours. Huge difference.

[veljkoz]

@Kyle: How is it different exactly? Some example maybe?