sharkbait
sharkbait

Reputation: 3040

Oracle built-in function to present float value

I wrote this statement:

TRUNC (v_Valutazione, 2);

because I have a v_Valutazione value like this:

-,9165786879898

In this way, with the trunc function, I obtain -,91.

I want instead something like -,92 .

Is this possible with one function?

Upvotes: 0

Views: 146

Answers (1)

David Jashi
David Jashi

Reputation: 4511

The word you are looking for, sir, is round()

Upvotes: 2

Related Questions