Archives of the TeradataForum

Message Posted: Tue, 19 Mar 2002 @ 12:48:14 GMT

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

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.

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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