Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extracting minutes from interval in user_jobs
Inquirer wrote:
> Hello,
> is there an "easy" way to extract the number of minutes from the
> Interval field from user_jobs?
>
> I have there something like "sysdate + 10/1440" but instead of brute
> force cutting "sysdate +" and
> "/1440" I wonder if there are functions which could do it more
> gracefully...
> Thank You in advance.
> Konrad
No.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Nov 24 2006 - 17:05:04 CST