Re: Find First of Month

From: Bob Jones <email_at_me.not>
Date: Fri, 14 Jul 2006 04:32:27 GMT
Message-ID: <v7Ftg.64769$fb2.8961@newssvr27.news.prodigy.net>

"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message news:e93scc$hvb$03$1_at_news.t-online.com...
> DA Morgan schrieb:
>> 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.
>
> Alternatively
> SELECT trunc(SYSDATE+90,'MM') FROM dual;
>

Not exactly the same when the date is say 31-JAN-2007. Received on Thu Jul 13 2006 - 23:32:27 CDT