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

  50854 Points

  12100 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

  52202 Points

  15507 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

  8069 Points

  2780 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.