how to have the right sum of type Time with sql

Posted by kawtousse on Stack Overflow See other posts from Stack Overflow or by kawtousse
Published on 2010-06-16T15:08:35Z Indexed on 2010/06/16 15:12 UTC
Read the original article Hit count: 125

Filed under:

hi , i have 2 fields called Timefrom and TimeUntill the duration is calculated in TimeSpent.

The colonne timeFrom is like the followine: 10:00:00 the colonne timeUntill is like the following: 12:00:00 the time spent colonne has the value: 02:00:00.

My goal is to calculate the sum of timeSpent.

PLease help.

© Stack Overflow or respective owner

Related posts about sql