Re: Time calculation in sqlplus

Assuming end_time and start_time are defined as date, then

end_time - start_time = seconds_worked

and

to_char( seconds_worked, 'hh:mi:ss' ) shows the results in human readable format.

<cleans_at_hotmail.com> wrote in message news:90fu6d$m9k$1_at_nnrp1.deja.com...
> Hi
>
> I am working on employees attendance system. The main table logs
> in the start_time and end_time everyday for each employee. Now i want
> to calculate the difference between these two fields to achieves no of
> Hours/Minutes every employee has put in each day.
>
> Could somebody show the way to do this.
>
> Thanks
> Clement
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 04 2000 - 18:20:36 CET