Re: Date difference problem in PL/SQL

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Nov 2003 11:26:37 -0800
Message-ID: <2687bb95.0311111126.3f354661@posting.google.com>

"Paul Tomlinson" <rubberducky703_at_hotmail.com> wrote in message news:<bor0k2$1hhjo0$1_at_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 -- Received on Tue Nov 11 2003 - 13:26:37 CST