Rounding in SQL

Question

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.

Answer 1

It is possible to truncate the numbers after the decimal point with the function TRUNC but if the value is up to 488,999 the result will be 488.

The query would be:

TRUNC((A.PESO * 20),0)

See example: http://sqlfiddle.com/#! 4/2b76e4/9

If you want to round even the correct value would be 489 as a mathematical rule, in this case it would be the function ROUND:

ROUND(A.PESO * 20)

Example: http://sqlfiddle.com/#! 4/2b76e4/4