trunc({n}[,{m}])

Returns the value of the numeric expression n truncated to m decimal places. m can be negative, in which case the function returns n truncated to -m places to the left of the decimal point. If m is omitted, it returns n truncated to the integer place. n can be any real numeric value in the range of -1.797e308 <= n <= 1.797e308. m can be an integer value between -15 and 15 inclusive.

trunc({n}[,{m}]) takes the following syntax.

This example returns 47.385 truncated to the second decimal place.