Hi..

I notice that I got problem in my code:

Code:
SELECT sec_to_time(SUM(time_to_sec(Rendered))) FROM reg_att WHERE EMP_NO = '09300139';

in this query the output is : 103:52:27 // total hours.

but it's wrong it should only be 103:51 //if did not count the seconds.

Now my question is what would be the syntax to correct the result.


this is the sample data:

08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
08:00:00
07:56:42
07:55:45
Thank you so much.