Re: Find First of Month

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 14 Jul 2006 10:18:10 +0200
Message-ID: <e97jvt$pt7$01$1@news.t-online.com>

Bob Jones schrieb:

> "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. 
> 
> 

Yes, i know.
I read the post from Jeroen as well ;-)

Best regards

Maxim Received on Fri Jul 14 2006 - 03:18:10 CDT