Subtract one day from datetime

Question

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

User · Answer

I am not certain about what precisely you are trying to do, but I think this SQL function will help you:

SELECT DATEADD(day,-1,'2013-04-01 16:25:00.250')

The above will give you 2013-03-31 16:25:00.250.

It takes you back exactly one day and works on any standard date-time or date format.

Try running this command and see if it gives you what you are looking for:

SELECT DATEADD(day,-1,@CreatedDate)

User · Answer

This should work   select DATEADD day  -1  convert date  GETDATE

User · Answer

You can try this   Timestamp 2008-11-11 13 23 44 657   SELECT DATE SUB OrderDate INTERVAL 1 DAY  AS SubtractDate FROM Orders   output  2008-11-10 13 23 44 657  I hope  it will help to solve your problem

User · Answer

SELECT DATEDIFF       DAY       DATEDIFF DAY   CreatedDate  -1        GETDATE

User · Answer

Try this  may this will help you  SELECT DATEDIFF DAY  DATEADD DAY -1  2013-03-13 00 00 00 000     GETDATE

User · Answer

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

User · Answer

To be honest I just use   select convert nvarchar max   GETDATE    112    which gives YYYYMMDD and minus one from it    Or more correctly   select convert nvarchar max   GETDATE    112  - 1    for yesterdays date   Replace Getdate   with your value OrderDate  select convert nvarchar  max  OrderDate 112 -1 AS SubtractDate FROM Orders   should do it

User · Answer

Apparently you can subtract the number of days you want from a datetime   SELECT GETDATE   - 1  2016-12-25 15 24 50 403

User · Answer

To simply subtract one day from todays date   Select DATEADD day -1 GETDATE       original post used -7 and was incorrect

[sql] Subtract one day from datetime

Examples related to sql

Examples related to sql-server

Examples related to datetime