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

Home -> Community -> Usenet -> c.d.o.misc -> best way to compare date, "more than one minute old"

best way to compare date, "more than one minute old"

From: Mark Harrison <mh_at_pixar.com>
Date: Tue, 31 Jul 2007 23:58:35 GMT
Message-ID: <L0Qri.30852$2v1.18892@newssvr14.news.prodigy.net>


I have a table with a DATE field called "started". What's the best way to search for rows where started is less than systime - 1 minute?

Here's what I'm using now. Is there a better way?

    select * from mytable
    where started<sysdate-(1.0/1440); -- 1440 minutes per day

Many TIA!
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Tue Jul 31 2007 - 18:58:35 CDT

Original text of this message

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