IQ uptime?

[Former Member]

Hi all,

Very simply, how to determine the uptime for IQ within IQ?  I can get it by searching the iqmsg file but need a method from within IQ.  My google-fu is working against me today.

jason

[Former Member · Accepted solution]

select property('StartTime')

Example:

DECLARE @UPTIME_DAYS INTEGER

DECLARE @UPTIME_HOURS INTEGER

DECLARE @UPTIME_MINUTES INTEGER

SELECT DATEDIFF(day, property('StartTime'), CURRENT TIMESTAMP) into @UPTIME_DAYS

SELECT DATEDIFF(hour, property('StartTime'), CURRENT TIMESTAMP) % 24 into @UPTIME_HOURS

SELECT DATEDIFF(minute, property('StartTime'), CURRENT TIMESTAMP) % 60 into @UPTIME_MINUTES

select @UPTIME_DAYS || ' days ' || @UPTIME_HOURS || ' hours ' || @UPTIME_MINUTES || ' minutes '

Output:

132 days 15 hours 40 minutes