Subtract one day from datetime

datetime, sql, sql-server

Solution

Try this

SELECT DATEDIFF(DAY,  DATEADD(day, -1, '2013-03-13 00:00:00.000'), GETDATE())

OR

SELECT DATEDIFF(DAY,  DATEADD(day, -1, @CreatedDate), GETDATE())

Problem

I have a query to fetch date diff between 2 datetime as : ``` SELECT DATEDIFF(DAY, @CreatedDate , GETDATE()) Ex : SELECT DATEDIFF(DAY, '2013-03-13 00:00:00.000' , GETDATE()) ``` I need to have a query work like this which will subtract a day from created day: ``` SELECT DATEDIFF(DAY, **@CreatedDate- 1** , GETDATE()) ```

Original source