TimestampDifference

select
       extract( day from diff )    days
     , extract( hour from diff )   hours
     , extract( minute from diff ) minutes
     , extract( second from diff ) seconds
from
       (
              select
                     max(n1) - min(n1) diff
              from
                     XX_DEBUG
       )