Wiki: TRUNC

TRUNC#

Functionality: #

This Oracle function will return number to the indicated number of decimal places (not rounded)

Also see the numeric usage of the TRUNC function

Parameters:#

NUMBER	The original number
PLACES	(optional) The number of decimal places (default is 0)

Returns: #

Number

Errors:#

None

Example:#

trunc(~,2) will return 3.52 if the passed number is 3.5200000 to 3.5299999

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor