get date before three days ago

Question

User-952877843 posted

i have this table 

id    date

1      2010-08-26

2      2010-08-24

3      2010-08-23

i want to that date column where date ago=3 in sql

i wrote this code but not working fine

SELECT  date from tb where date> DATEADD(day, -3 SYSDATETIME())

Answer 1

User-474980206 posted

you need to to get the date only:

SELECT  date from tb 
where date > DATEADD(day, -3, CONVERT(date, GETDATE()))

Answer 2

User-1716253493 posted

Use brackets for date word SELECT [Date] ...

SELECT  [date] from tb where date < CAST(DATEADD(day, -3,GetDate()) as Date)

GetDate() get current datetime

CAST as Date to remove time part

Answer 3

User-369506445 posted

hi

you can use DATEDIFF function for find different date between 2 fields ,  please try below query

SELECT [date] from tb where  DATEDIFF(DAY,[date], getdate()) >= 3