Blocked transactions view in hana
M_BLOCKED_TRANSACTIONS view contains BLOCKED_TIME as one of the column, what is the unit it is in?
Is it seconds or minutes?
Message was edited by: Tom Flanagan
BLOCKED_TIME is a timestamp (start of the blocking situation), so it doesn't have a dedicated unit. You may have a look at SQL: "HANA_Locks_Transactional_LockWaits" (SAP Note 1969700) to understand how to display the timestamp and how to calculate the number of seconds between the BLOCKED_TIME and the current timestamp:
TO_CHAR(T.BLOCKED_TIME, 'YYYY/MM/DD HH24:MI:SS') WAIT_SINCE,
LPAD(SECONDS_BETWEEN(T.BLOCKED_TIME, CURRENT_TIMESTAMP), 7) WAIT_S,
If you want to substract 10 minutes from the current timestamp, you can use: