Re: TIME Arithmetic

The short answer is yes. Oracle's date type stores time to the seconds. In your example below, if v_start and v_end are both date data types and v_lapse is a number, v_lapse will be the elapsed time in days. Muliply by 86,400 to get the seconds, or use the to_date function to to get the elapse time formated.

HTH
   James

In article <362C8FDD.AB066676_at_rl.af.mil>, Vinnie <salernov_at_rl.af.mil> wrote:

>Can you subtract one time from another?
>
>EX.
>
>v_start := SYSDATE;
>v_end := v_stop_time;
>
>v_lapse := v_end - v_start
>
>Thanks
>Vinnie
>Litton/PRC

--

lorenzen_at_yuck.net             | Life is complex; it has
                              |   real and imaginary parts