Re: Oracle reports

From: Benjamin Butler <benjamin.butler_at_lineone.net>
Date: Tue, 16 Feb 1999 22:36:21 +0000
Message-ID: <36C9F2E5.36279AD2@lineone.net>

Hello

I could be wrong but you could use Add_Months with -6. I can't recall the syntax offhand but it is a basic SQL date manipulation command.

Ben.

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 Tue Feb 16 1999 - 16:36:21 CST