Small problem with DateType

[BUSHII]

I have simply query:
SELECT time_start-time_end
FROM table1
WHERE [.......]

When I run this query, then I see:
1900-01-01 00:38:00.000
1900-01-01 03:43:00.000
1900-01-01 03:02:00.000
1900-01-01 04:31:00.000

I want to get sum of all this dates and times. How Can I do this?

Best regards
BUSHII

[David Portas]

SELECT SUM(DATEDIFF(S,time_start,time_end)) AS total_seconds
FROM Table1

--
David Portas
SQL Server MVP
--