Program to find the difference in time in seconds

Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 315
SELECT  (DATEDIFF(millisecond,@t1,@t2) - (((DATEDIFF(millisecond,@t1,@t2))/60000)*60000)) /1000 AS ElapsedTimeInSeconds;

Comments or Responses

Posted by: Amatya on: 2/16/2016 Level:Starter | Status: [Member] | Points: 10
Can we measure in NanoSecond. I want more effective elapsed time..

Login to post response