Timestamp Difference from Same Column

building reports desktopintelligence
1

Hi All,

I would like to know how to find the timestamp difference from same column (I.e. Previous Value & Current Value)

For Example :-
Eventtime
1)04/13/2009 04:40:18
2)04/13/2009 04:40:15
3)04/13/2009 04:36:00

I’m trying to find the difference between 2-1 and 3-2.

In case, It can’t resolve at DESKi and I’m fine to resolve it at Designer level.
Database :- SQLServer -2005

Thanks
Shree
:expressionless:

snbhandari9 :us: (BOB member since 2006-08-10)

2

This was already there in previous posts.
Check this out
https://bobj-board.org/t/39477

bobjkb :india: (BOB member since 2004-03-19)

3

Link you have sent me . Doesn’t have any solution related to SQL-Server Database. :frowning:

snbhandari9 :us: (BOB member since 2006-08-10)