Archives of the TeradataForum

Message Posted: Thu, 01 Nov 2001 @ 16:45:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Would it be possible to do a self join on this table (dbc.logoff) to capture the date and time for events 'logoff' and 'logon' based either on username and session. Then take the time difference between logon and logoff time.

Not a SQL Guru, but would that be possible. And if it is, can someone give us an example?.

Thanks

Al

	<Prev	Next>		<<First	<Prev	Next>	Last>>