[RESOLVED] how to read System.Time, how accurate?

[josephine]

G'day all.

how to determine execute time of a SQL query?

sTime=read system time
-> execute a NonQuery on a database
eTime=read system time

calculate the diff.. dTime=eTime-sTime..

no go..
Error: Value of type 'System.TimeSpan' cannot be converted to 'Date'.

any ideas on how to get the diff???

thanks,

[nmadd]

You didn't say what version you are using, but if you are using the 2.0 Framework then you can use the Stopwatch class to accurately measure elapsed time:
http://msdn2.microsoft.com/en-us/lib...ch(vs.80).aspx

[josephine]

You didn't say what version you are using, but if you are using the 2.0 Framework then you can use the Stopwatch class to accurately measure elapsed time:
http://msdn2.microsoft.com/en-us/lib...ch(vs.80).aspx

am using 2.0 Framework.
and the suggested class is perfect!!

many thanks @nmadd!!!!