Re: Oracle reports

From: Victor Krokhmal <kvz_at_ncc.moc.kw>
Date: Fri, 26 Feb 1999 23:01:24 +0300
Message-ID: <36D6FD94.C220A8A9@ncc.moc.kw>

What's about this:

ADD_MONTHS(TRUNC(sysdate,'MONTH'),-6)

dredogg wrote:

> I'm trying to create a report in reports 4.5 that reports on
> six months worth of data. I tried using sysdate - 180 as the
> criteria but this only works if you are at the beginning of a
> month. I need another way to go back six month.
> --
> Posted via Talkway - http://www.talkway.com
> Surf Usenet at home, on the road, and by email -- always at Talkway.

Received on Fri Feb 26 1999 - 14:01:24 CST