Re: how to count elapsed time between sysdate and some saved timestamp?

On Wed, 7 May 2008 18:45:04 +0200, "buu" <aha_at_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