By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
JOB_NM | TO_CHAR(TRUNC(SYSDATE)+AVG(DT-TRUNC(DT)),'HH24:MI') |
---|---|
a | 15:40 |
b | 21:40 |
JOB_NM | TO_CHAR(TRUNC(SYSDATE)+AVG(DT-TRUNC(DT)),'HH24:MI') |
---|---|
a | 15:40 |
b | 21:40 |