get date before three days ago[Answered] RSS

• • Reply
  chnar

  Member

  49 Points

  154 Posts

  get date before three days ago

  Aug 26, 2018 02:55 PM|chnar|LINK

  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())

• • Reply
  bruce (sqlwo...

  All-Star

  57874 Points

  15510 Posts

  Re: get date before three days ago

  Aug 26, 2018 05:04 PM|bruce (sqlwork.com)|LINK

  you need to to get the date only:

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

  
  
  

  bruce (sqlwork.com)
• • Reply
  oned_gk

  All-Star

  52523 Points

  15675 Posts

  Re: get date before three days ago

  Aug 27, 2018 01:22 AM|oned_gk|LINK

  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

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  vahid bakkhi

  Star

  8119 Points

  2778 Posts

  Re: get date before three days ago

  Aug 27, 2018 04:39 AM|vahid bakkhi|LINK

  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

  
   

  vahid bakhtiary
  
  Please MARK AS ANSWER if suggestion helps.