Archives of the TeradataForum
Message Posted: Thu, 01 Nov 2001 @ 16:45:21 GMT
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?.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|