Re: Decode- Please Help

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 04 Nov 1998 21:37:19 GMT
Message-ID: <3640bdbc.1295240@news.siol.net>

On Wed, 4 Nov 1998 16:53:34 +0200, "Grinberg L." <leon_at_grant.kharkov.ua> wrote:

>
>Jurij Modic wrote in message <36401039.2857357_at_news.siol.net>...
>>
>>SELECT ADD_MONTHS(TRUNC(ADD_MONTHS(sysdate,18),'YEAR'),12)-1
>>FROM dual;
>
>Or more brief
>
>SELECT ROUND(ADD_MONTHS(sysdate,24),'YEAR')
>FROM dual;

You're right, except that you have to subtract one day from your result to get the result that was required.

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Nov 04 1998 - 15:37:19 CST