Re: Bringing Back Data for Previous 11 Months + This Month
Date: Fri, 29 Jun 2001 23:11:55 -0500
Message-ID: <9kc%6.131$uk1.8665_at_nnrp1.sbc.net>
try:
> ADD_MONTHS(TRUNC(SYSDATE,'MONTH'),-11)
"Clay Mitchell" <clay.mitchell_at_bankofamerica.com> wrote in message
news:b0e58ae3.0106280950.34dd9ab_at_posting.google.com...
> Ok, here's the deal. I need to bring back information in a table for
> this month (june 2001), plus the previous year (back to july, 2000).
> if i use add months, and do > add_months(sysdate, -11) it pulls back
> everything from this date (28th) of july 2000, which doesn't work
> because i need everything back from july.
>
> if i do > add_months(sysdate, -12) it pulls back the last few days
> from june 2000, which skews my results.
>
> how can i round it off to only pull back from the beginning of july?
>
> any help would be appreciated.
Received on Sat Jun 30 2001 - 06:11:55 CEST