Nest a query within main code

[harishgg1]

hi hope this helps

TO_CHAR(FLOOR(main.OTGTM / 60), 'FM900') || ':' || TO_CHAR(MOD(main.OTGTM, 60), 'FM00') AS HH_MM