2
I need to perform a rounding of a result. Oracle looks like this:
SALDO_TONELADA = (A.PESO * 20,0);
The value of the column A.PESO
is of 24.432
and multiplied by 20 gives 488.640
.
My goal was to receive a value only of 488
, no point and no values after the point.
I’ve tried using the ROUND
but it didn’t solve my problem.
I know that in Excel has a formula that formats a certain field like this:
=esquerda(488.640; 3)
And as an answer would have 488
.
Can you tell me if in Oracle there is something to format the field to bring only x characters?
I do not know if it was clear, but I need the result to be 2 or 3 characters to correct the calculation of other columns that depend on this result.
Related or duplicate: https://answall.com/q/5746/101 and https://answall.com/q/219211/101
– Maniero
There is no example to test and it does not say what would be "not enough". It is difficult to help you
– Sorack
This example I don’t have, I’m still developing within the application. Basically, I need to multiply a result from weight to value. and as a precise answer this value has only 3 characters
– Victor Andrade