RE: Help with date calculation

From: Javier Morales <Javier_at_infojobs.net>
Date: Thu, 16 Nov 2000 19:32:18 +0100
Message-Id: <10682.122281@fatcity.com>

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

---

 Javier Morales - javier_at_infojobs.net
 Administraci=F3n Bases de Datos Oracle - InfoJobs.net  Tel. +34 902 10 60 90 Ext. 2067
 Fax. +34 (93) 580 56 60
=20

-----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);

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

  ---

Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays! http://calendar.yahoo.com/
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: LOREN SUMMERS
  INET: loren_summers_at_yahoo.com

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