oracle sql ÇóÖÖ²Ëʱ¼ä

-- create by zh
-- n ÊÇ×÷ÎïµÄʱ¼ä,x ÊÇÏ£ÍûÔÚ¼¸µã³ÉÊì,·µ»Ø²¥ÖÖµÄʱ¼ä
with t as
(
select 64 n,9 x from dual union all
select 64 n,13 x from dual union all
select 64 n,17 x from dual union all
select 64 n,20 x from dual
)
select '³ÉÊìʱ¼ä:'     || lpad(to_char(n),4,' ')                            || '   ;' ||
       'ժȡʱ¼ä:'     || lpad(to_char(x),4,' ')                            || '   ;' ||
       '²¥ÖÖʱ¼ä:'     || lpad(to_char(mod(24+( x - mod( n,24)),24)),4,' ') || '   ;'
  jg from t