database:mssql:sum_datetime_diff

Differences

This shows you the differences between two versions of the page.


—database:mssql:sum_datetime_diff [2019/10/31 09:04] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== 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:04
  • by 127.0.0.1