Archives of the TeradataForum

Message Posted: Mon, 15 Mar 2004 @ 13:59:11 GMT

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

> SELECT  SessionID, QueryID
> FROM DBC.QryLog
> with (sum(StartTime - LastRespTime)) MINUTE(4) TO SECOND(2) by SessionID;

This worked for me:

with sum(LastRespTime - StartTime MINUTE(4) TO SECOND(2)) by SessionID;

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