On Wed, 7 May 2008 18:45:04 +0200, "buu" <aha@a.com> wrote:

>question is simple... I have an date field in an table and I would like to
>measure time difference (minutes or sec.) between current time and that
>field.
>
>at wich way you propose?
>

Assuming a non-paleolithic version of Oracle (I appreciate, you, as
someone asking help, can't be bothered to post it, as you assume
Oracle never changes), one would just subtract the two dates (the unit
of a date is a day), so you get the difference expressed as a days
fraction and feed that through the numtodsinterval function.

--
Sybrand Bakker
Senior Oracle DBA