Archives of the TeradataForum
Message Posted: Fri, 12 Mar 2004 @ 21:05:51 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|