Re: Date difference problem in PL/SQL

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Tue, 11 Nov 2003 11:14:27 -0500
Message-ID: <kbKdnaamhrmCliyi4p2dnA@comcast.com>

this doesn't require a fancy function

date arithmetic is directly supported and results in days between two dates

ie, recent_date - past_date return the number of days between the two dates

simply multiple the result * 24 * 60 to get minutes

"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
>
>
Received on Tue Nov 11 2003 - 10:14:27 CST