Converting String to Integer and then adding them
663608Oct 8 2008 — edited Oct 8 2008Guys
I got a problem..I need to convert string to integer.My program generates execution time of an individual sql statement and it is returning the time as String.Ex:00:00:00:.000372
And I am going to run a group of sql statements and finally i need to find the sum of all execution times...
Suppose I run three sql statements..
Their execution time is 00:00:00:.000372 00:00:00:.0002 and 00:00:00:.00021 I need to get the output as
00:00:00:000782( which is the sum of above three execution times)
Can any one pls suggest me what to do.