SQL to retrive 1 month data which is 4 months old

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Parul katiyar
    New Member
    • Aug 2016
    • 1

    SQL to retrive 1 month data which is 4 months old

    I need an sql which will retrieve data for last 1 month which is 4 months old. eg if today is 1/8/2016 then need data for whole April.Also condition is if my sql is run on any day of the current month it should still retrieve data from 1st of April for whole month.
  • Cbold
    New Member
    • Aug 2016
    • 6

    #2
    Are your dates correct? Wouldn't four months old be September 2015?

    Comment

    Working...