Small problem with DateType

#1 (**permalink**) 02-29-2008, 04:37 AM

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

#2 (**permalink**) 02-29-2008, 04:37 AM

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

--
David Portas
SQL Server MVP
--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode