Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL server select to get sum of hours

SELECT DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', YourFieldName)), '00:00:00.000') as time FROM YourTableName
Source by www.codeproject.com #
 
PREVIOUS NEXT
Tagged: #SQL #server #select #sum #hours
ADD COMMENT
Topic
Name
7+9 =