node

 SELECT 

    node_name AS "Application Node",

    TO_CHAR(MIN(start_date), 'DD-MON-YYYY HH24:MI:SS') AS "Cycle Start Time",

    TO_CHAR(MAX(end_date),   'DD-MON-YYYY HH24:MI:SS') AS "Cycle End Time",

    ROUND((MAX(end_date) - MIN(start_date)) * 1440, 2) || ' minutes' AS "Total Time (mins)",

    FLOOR((MAX(end_date) - MIN(start_date)) * 24) || 'h ' ||

    MOD(FLOOR((MAX(end_date) - MIN(start_date)) * 1440), 60) || 'm ' ||

    MOD(FLOOR((MAX(end_date) - MIN(start_date)) * 86400), 60) || 's' AS "Total Duration"

FROM 

    applsys.ad_patch_runs

WHERE 

    patch_driver_id = (

        SELECT patch_driver_id 

        FROM applsys.ad_patch_drivers 

        WHERE driver_name = 'Merged Driver'   -- this is the driver for your 13-patch cycle

           OR patch_driver_id = (SELECT MAX(patch_driver_id) FROM applsys.ad_patch_runs)

    )

GROUP BY 

    node_name

ORDER BY 

    node_name;