Format a 6 digit number field in JD Edwards table as HH24:MI:SS

Published: 15/05/2019
Format a 6 digit number field in JD Edwards table as HH24:MI:SS
Source: ASKTOM.ORACLE.COM

I have this value (170443) in a column which I would want to display as 17:04:43. I have written this piece of code to achieve this but seeing error ORA-01850: hour must be between 0 and 23. What is the solution? <code>SELECT CASE WHEN LVUPMT= 0 T...

Read more
Related news
Comment