Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: extracting minutes from interval in user_jobs

Re: extracting minutes from interval in user_jobs

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 24 Nov 2006 15:05:04 -0800
Message-ID: <1164409500.248515@bubbleator.drizzle.com>


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.org
Received on Fri Nov 24 2006 - 17:05:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US