I've got a requirement where I need to round a decimal (Length 19, Scale 7) value to the 4th decimal.
In SQL, the example function and result will look like:
select ROUND(26.086464,4) -> result is 26.086500
I've had a look at previous posts and the Developer's Guide, but I can't see how the CEIL, FLOOR, round_inf, DecimalToDecimal(Number,Rounding) function can be of any use as it only caters for decimal length of 10 and a scale of 2.
Any idea how I can round to the 4th decimal place as done by the SQL above?
Rounding to 4 decimal places
Moderators: chulett, rschirm, roy
Have you seen the following?
viewtopic.php?p=338081
Make sure you have scale of the column set to your desired value, i.e. 4.
Joseph Neasy.
viewtopic.php?p=338081
Make sure you have scale of the column set to your desired value, i.e. 4.
Joseph Neasy.