Archives of the TeradataForum
Message Posted: Thu, 01 Nov 2001 @ 21:12:11 GMT
It's a little trickier than Dave mentioned, only because you have to handle the times differntly depending on whether you span days or not. For example, if the logon occurred on 1/1/1/ 21:00:00 and logged off on 1/2/1 03:00:00, you can simply substract the end time from the from time. Not impossible ny any means, but it does involve a little more thought.
Thomas F. Stanek
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|