Archives of the TeradataForum
Message Posted: Tue, 19 Mar 2002 @ 12:48:14 GMT
Elapsed time is not available anywhere within Teradata today. There is talk of a "query log" being added to v2r5 which will record exactly that info. If you've got the logon time in accesslog then you could join to the "logoff" row on dbc.logonoff to pick up the logoff date/time from there.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|