Re: Define a job to run once an year

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 24 Dec 2004 16:13:28 -0800
Message-ID: <1103933608.212012.256950@z14g2000cwz.googlegroups.com>

<snip>
> Why not resolve this using LAST_DAY and ADD_MONTHS, so the O/P learns
> something from it, and can address it on his own next year.
<snip>

Well as always... there is more then one way to resolve this. Built in date functions like you mentioned being the other option. Writing a custom function to build date could be another one. I just chose simple date mathematics because it was easy to construct. Happy holidays.
/Rauf Received on Fri Dec 24 2004 - 18:13:28 CST