Good morning,
I'm having a trouble to convert a SUM(NUM*NUM) to HH:MM:ss
My select is the above
MAX(TRUNC((TORDENS_ROT.TEMPO*TORDENS_MOVTO.QUANTIDADE),2)) TEMPO_PADRAO_NUMBER,
And the result is a number like:
455,53
127,89
320,9
And I would like to the result comes in "HH:MM:ss" like
"02:35:30" rather than "155,5"
"01:12:03" rather than "72,05
I already tried a lot of thing, like the links above
http://stackoverflow.com/questions/11003918/oracle-convert-seconds-to-hoursminutesseconds
http://stackoverflow.com/questions/3978656/convert-number-to-time
But no one of these solutions had worked for me
Has anyone know some solution?