Re: Date difference problem in PL/SQL

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 11 Nov 2003 13:14:42 -0800
Message-ID: <4b5394b2.0311111314.41b16367@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 between two DATE values is in units of Days, with anything less in the fractional part to the right of the decimal point.

(converting from decimal days to decimal minutes is left as an exercise for the reader).

Next time try to RTFM. Simple topics like this are in there.

HTH
Ed Received on Tue Nov 11 2003 - 15:14:42 CST