INSERT INTO downtime(stop_time,start_time) VALUES('$STOP','$START');
SELECT d1.did, 
.......d1.stop_time - (select d2.start_time 
.....................from downtime d2
.......................where d2.did = (select max(did)
.........................................from downtime
.........................................where did <  d1.did)) uptime                                                   
FROM downtime d1
INTO temp t1_downtime with no log;

SELECT did, uptime FROM t1_downtime
WHERE did=(select max(did) from t1_downtime)
INTO temp t2_downtime with no log;

SELECT did,
..........cast(cast(uptime as interval day to second)
..........as interval second( 9 ) to second)|| ' '+ 0  uptime                     
FROM t2_downtime
INTO temp t3_downtime with no log;

UPDATE downtime
   SET uptime=(select uptime from t3_downtime where did=downtime.did);
!EOF