see below:
Get the Time Difference between records
with this record on the TimeStamp, I wish to extract the (time difference in seconds between the consecutive records) as another field name TimeDifference, is that possible? how to modify the query? thanks.
see below:
see below:
Prasenjit DeyPosted Sep 26, 2013, 6:00 AM
Choose any one, which you need
select DATEDIFF(day,2007-11-30,2007-11-20) AS NumberOfDays,
DATEDIFF(hour,2007-11-30,2007-11-20) AS NumberOfHours,
DATEDIFF(minute,2007-11-30,2007-11-20) AS NumberOfMinutes
FROM test_table