Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help with date calculation
sorry... you wrote one extra '*60' :-)
so, you calculate >20 seconds! ;-))
I think this is the correct solution...
so,=20
date-date =3D number of days (date-date)*24 =3D number of hours (date-date)*24*60 =3D number of minutes
then
select... bla bla bla...
where (adate-bdate)*24*60 > 20;
hmmm... so I think! :P
-----Mensaje original-----
De: LOREN SUMMERS [mailto:loren_summers_at_yahoo.com]
Enviado el: jueves 16 de noviembre de 2000 19:17
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Help with date calculation
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)>2= 0);
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Thu Nov 16 2000 - 12:32:18 CST