Re: Find First of Month

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 13 Jul 2006 00:16:47 +0200
Message-ID: <e93scc$hvb$03$1@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;

To OP - if i not misunderstood you, for 04/15/2006 you'll get 07/01/2006. If you need the 1st of following month, you have to slightly modify one of both expressions.

Best regards

Maxim Received on Wed Jul 12 2006 - 17:16:47 CDT