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: 122
sql
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