How can I get the sum of multiple datetime values?

by

Convert minutes into seconds

SUM() the seconds

Convert back to minutes

The following will give you the SUM of seconds:

SET @Seconds = SELECT SUM(DATEDIFF(SECOND, [START_TIME], [END_TIME]))

The following then turns that into a datetime object:

select convert(varchar(8), dateadd(second, @Seconds, 0),  108)

Or as 1 query:

SELECT convert(varchar(8), dateadd(second, SUM(DATEDIFF(SECOND, [START_TIME], [END_TIME])), 0),  108)

More Related Contents:

  1. Sql Server string to date conversion
  2. What is the significance of 1/1/1753 in SQL Server?
  3. How to get Time from DateTime format in SQL?
  4. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  5. Date conversion and culture: Difference between DATE and DATETIME
  6. How to calculate difference in hours (decimal) between two dates in SQL Server?
  7. SQL Server – error when creating stored procedure
  8. How can foreign key constraints be temporarily disabled using T-SQL?
  9. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  10. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  11. Parameter Sniffing (or Spoofing) in SQL Server
  12. How can I select the first day of a month in SQL?
  13. Maximum size of a varchar(max) variable
  14. best way to convert and validate a date string
  15. Concatenating Column Values into a Comma-Separated List
  16. Is there a way to simplify a NULL compare of 2 values
  17. TSQL Try / Catch within Transaction or vice versa?
  18. What is the maximum number of characters that nvarchar(MAX) will hold?
  19. TSQL: Create a view that accesses multiple databases
  20. Sequence as default value for a column
  21. Aggregate bitwise-OR in a subquery
  22. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  23. How to compare datetime with only date in SQL Server
  24. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  25. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  26. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  27. Cannot bulk load. Operating system error code 5 (Access is denied.)
  28. Does query plan optimizer works well with joined/filtered table-valued functions?
  29. What are row, page and table locks? And when they are acquired?
  30. How does SQL Server decide format for implicit datetime conversion?

Leave a Comment