I need to get a numeric field in a sql query in which 5 decimal places are always shown, that is, if the number has more than 5 decimal places, it only shows the first 5 and if it has less than 5 decimal places, they are filled with 0 until it reaches the 5 decimals. I think it has been understood but just in case I give examples:
If it returns 1.23 it would output 1.23000 If it returns 1 it would output 1.00000 If it returns 1.2345678 it would output 1.23456
I have tried with the TRUNC() function and if it has more than 5 decimals it shows it to me well but if it has less it does not fill it with 0, any idea? Thank you!
fixed below