fetch data from 3month ago to today RSS

• • Reply
  

  nazlin

  Member

  135 Points

  173 Posts

  fetch data from 3month ago to today

  Apr 13, 2012 11:39 AM|LINK

  hi dear ,

  I want fetch many record from 3 month ago to today.how can fetch them

  How can I check whether this value is older than 3 months ago using a SQL query?

  my code is:

  select * from orders  r where r.dateInsert  < DATEADD(month, -3, GETDATE()

  is my script true?

  I think for I am
• • Reply
  

  kedarrkulkar...

  All-Star

  34391 Points

  5529 Posts

  Re: fetch data from 3month ago to today

  Apr 13, 2012 11:42 AM|LINK

  nazlin

  hi dear ,

  I want fetch many record from 3 month ago to today.how can fetch them

  How can I check whether this value is older than 3 months ago using a SQL query?

  my code is:

  select * from orders  r where r.dateInsert  < DATEADD(month, -3, GETDATE()

  is my script true?

  if you want to get data from last 3 month to today... then u r query need little change

  as this

  select * from orders  r where r.dateInsert  > DATEADD(month, -3, GETDATE())

  it should be greater than comarison operator

  hope this helps...

  Cheers!
  KK
  
  Please mark as Answer if post helps in resolving your issue
  My Site
  • Marked as answer by nazlin on Apr 13, 2012 11:53 AM
• • Reply
  

  sairam62.cse

  Participant

  993 Points

  311 Posts

  Re: fetch data from 3month ago to today

  Apr 13, 2012 11:43 AM|LINK

  select * from orders  r where r.dateInsert  > DATEADD(month, -3, GETDATE()

  If The Answer is Satisfied Plz Select Mark As Answer in my Place,
  s.sairam
  • Marked as answer by nazlin on Apr 13, 2012 11:54 AM