Re: WHERE clause DATE question

From: Michael Ringbo <mri_at_dde-nospam.dk>
Date: Fri, 12 Mar 1999 10:56:47 +0100
Message-ID: <36E8E4DF.BBB0047F@dde-nospam.dk>

....where my_date > add_months(sysdate,-6)...

regards,

Michael Ringbo

Rich D wrote:

> I need to create a view using a WHERE clause that involves a date column. I
> would like to see records with a date within the last 6 months only. I am
> assuming that I need to do something using SYSDATE, but I haven't seen how
> to get what I need.
>
> Does anyone have any suggestions?
>
> Thanks,
>
> Rich Dolan
Received on Fri Mar 12 1999 - 03:56:47 CST