Show pageOld revisionsBacklinksExport to PDFBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Sum datetime difference in MSSQL ====== Get the SUM of seconds: <code>SET @Seconds = SELECT SUM(DATEDIFF(SECOND, [START_TIME], [END_TIME]))</code> Turn that into a datetime object: <code>SELECT CONVERT(VARCHAR(8), dateadd(SECOND, @Seconds, 0), 108)</code> Or as 1 query: <code>SELECT CONVERT(VARCHAR(8), dateadd(SECOND, SUM(DATEDIFF(SECOND, [START_TIME], [END_TIME])), 0), 108)</code> database/mssql/sum_datetime_diff.txt Last modified: 2019/10/31 09:04by 127.0.0.1