Time Calculation on Numbers

In Forums sometimes I read questions on how to find out the difference between two times which are stored as characters Here are some possible answers Subtraction declare @t1 v archar ( 5 ), @t2 varchar ( 5 ), @sum float select @t1 = '12.56' , @t2 = '7.58' set @sum = cast ( @t1 as float )- cast ( @t2 as float ) --Method 1 : Convert to Datetime select convert ( varchar ( 5 ), dateadd ( day , 0 , replace ( @t1 , '.' , ':' ))- dateadd ( day , 0 , replace ( @t2 , '...(read more)

Source Click Here.