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 -> extracting minutes from interval in user_jobs

extracting minutes from interval in user_jobs

From: Inquirer <sdaman29_at_gmail.com>
Date: 23 Nov 2006 06:58:20 -0800
Message-ID: <1164293900.149271.278600@l12g2000cwl.googlegroups.com> 





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
Received on Thu Nov 23 2006 - 08:58:20 CST












Original text of this message













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