RE: Help with date calculation

From: LOREN SUMMERS <loren_summers_at_yahoo.com>
Date: Thu, 16 Nov 2000 10:13:35 -0800 (PST)
Message-Id: <10682.122280@fatcity.com>

Djordje,
I was pretty sure about the first one but I am not sure whether this is correct.
Can someone help mw with this date calculation. Really appreciate your help.

Thanks
Problem

All records where sydate - bdate > 20 minutes bdate is stored in seconds from 1970..
select * from timetable
 where

(sysdate-20/1440)-to_date('01-JAN-1970','DD-MON-YYYY')+bdate(24*60*60)>20);

• Djordje Jankovic <djankovic_at_corp.attcanada.ca> wrote:
  > As long as both adate and bdate are relative to the
  > same date the first
  > query:
  >
  > Select *
  > from timetable
  > where (adate-bdate) > 20 * 60;
  >
  > is OK.
  >
  > Djordje
  

  ---

Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays! Received on Thu Nov 16 2000 - 12:13:35 CST