At 10:32 +0300 9/18/02, adi wrote:
> Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30)
>I want to make a sql selection:
>SELECT * from table1 WHERE condition, and after that, to make sum of values
>of column "Duration" and display it.
>Any Help?
>tx
To display as seconds
SELECT *,sum(Duration) as durationsum from table1 WHERE condition
should work,
Thomas
On Wed, 18 Sep 2002 10:32:07 +0300 "adi" <[EMAIL PROTECTED]> wrote:
>
> Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30)
> I want to make a sql selection:
> SELECT * from table1 WH
Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30)
I want to make a sql selection:
SELECT * from table1 WHERE condition, and after that, to make sum of values
of column "Duration" and display it.
Any Help?
tx
-
