Calculate duration of session 1

[charanch]

Hello,

I have a table that collects the username and date/time they logged in and logged out and the session id. How would I calculate the duration of their visit?

Thanks for your help!

charles

 

[foxbox]

MS SQL has a datediff function. This gives the difference in seconds:

select datediff( n, login, logout)
from logtimes

hth,
Foxbox

 

[charanch]

Thank you very much. It works great.