Decode- Please Help

From: <lakkundi_at_msn.com>
Date: Wed, 04 Nov 1998 04:18:07 GMT
Message-ID: <71okhv$g0m$1@nnrp1.dejanews.com>

Need to write a select statement that takes a date (eg. 15-DEC-97) and adds 18 months to it. It must then print out the year-end (DEC 31) of that addition. For example, 18 months from Dec. 15 1997 is June 15, 1999, but the year-end result that would be displayed is Dec. 31, 1999.

I can write this with date functions but I need to make it more dynamic with a decode.
How do I do this. I tried and tried, please help..

Thanks so much for your help

Sam..


-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 03 1998 - 22:18:07 CST