Subject Re: [ib-support] Help - Sum(TimeType)
Author Ann W. Harrison
At 04:38 PM 7/25/2002 -0300, Ageu Duarte Junior wrote:

>I have a table with three Columns: The name is EmployeeTimeWork, and the
>columns are:
>EmplyeeID Char(3)
>DateWorked Date
>HoursWorked Time
>I need a statement to sum the hours worked between dates, I tried it:
>But doesn't Work.

Right. The problem is that you're using the time data type incorrectly.
It's not a number of hours, but a point during a day. For example, 10:00
is ten in the morning. You want it to be the sum of 5 + 5. Use a numeric


We have answers.