Archives of the TeradataForum

Message Posted: Fri, 12 Mar 2004 @ 21:05:51 GMT

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

Hi all,

I'm not very familiar with manipulation of timestamp and I would like to know how long time a session spent on Teradata.

I trying to get my answer with this buggy SQL :

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

Does anybody can fix my SQL?

Tahnk you

Rudel

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