Re: Find First of Month

FireGeek wrote:
> Looking for an SQL statement to return the first of the month 90 days
> following a given date. So, if my date is 04/15/2006 I would like
> 08/01/2006 returned.
>
> Help anyone?
>
> THANKS!!!
>
> FireGeek

SELECT LAST_DAY(ADD_MONTHS(SYSDATE, 2))+1 FROM dual;

A list of date functions with demos can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org