将时间的秒值转化为时分秒格式:
IF ( [时长]/3600>9 ) THEN
(
to_char (trunc ([时长]/3600,0))||':'||
lpad (to_char (trunc (mod([时长],3600)/60,0)),2,'0')||':'||lpad (to_char (mod([时长],60)),2,'0')
)
ELSE
(
lpad (to_char (trunc ([时长]/24/3600,0)),2,'0')||':'||
lpad (to_char (trunc (mod([时长],3600)/60,0)),2,'0')||':'||lpad (to_char(trunc (mod([时长],60),0)),2,'0')
)