Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: Mark.Powell@eds.com (Mark D Powell)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Date difference problem in PL/SQL
Date: 11 Nov 2003 11:26:37 -0800
Organization: http://groups.google.com
Lines: 15
Message-ID: <2687bb95.0311111126.3f354661@posting.google.com>
References: <bor0k2$1hhjo0$1@ID-116287.news.uni-berlin.de>
NNTP-Posting-Host: 68.42.97.55
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1068578798 27175 127.0.0.1 (11 Nov 2003 19:26:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 11 Nov 2003 19:26:38 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:133035

"Paul Tomlinson" <rubberducky703@hotmail.com> wrote in message news:<bor0k2$1hhjo0$1@ID-116287.news.uni-berlin.de>...
> Hello,
> 
> Does anyone have a routine which will return the (total) difference in
> minutes between two dates?
> 
> It doesn't look like Oracle provides any fancy date manipulation
> functions....
> 
> PT

The difference is expressed in days and fractions thereof so just
divide by the number of minutes in a day, 1440.

HTH -- Mark D Powell --