728x90
135초
SELECT
NVL((TRUNC(135/(60*60)))||':'||LPAD(TRUNC(MOD((135/60),60)),2,0),0) AS DRVN_DLTM_CNT
FROM DUAL
결과값 --> 0:02
135초
SELECT
NVL((TRUNC(135/(60*60)))||':'||LPAD(TRUNC(MOD((135/60),60)),2,0),0) AS DRVN_DLTM_CNT
FROM DUAL
결과값 --> 0:02