| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Define a job to run once an year
<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
 |
 |