TRUNC

=__TRUNC __ = ==__Argument: __ == ===TRUNC(column|expression,decimal places)  ===

D escription:
This fuction basically cuts off the number of decimal places stated in the argument. Trunc does not round the numbers, it just cuts them off at that certain place you want.

1. SELECT TRUNC(36.934,2) FROM dual
|| TRUNC(36.934,2) || || 36.93 ||

2. SELECT TRUNC(order_total,2) FROM f_orders
|| TRUNC(ORDER_TOTAL,2) || || 103.02 ||

<span style="display: block; color: #000000; font-family: 'Courier New', Courier, monospace; text-align: left;">3. SELECT TRUNC(price,3) FROM f_food_items
<span style="display: block; color: #000000; font-family: 'Courier New', Courier, monospace; text-align: left;">|| <span style="font-family: 'Courier New', Courier, monospace;">TRUNC(PRICE,3) || || <span style="font-family: 'Courier New', Courier, monospace;">3.59 || || 1.09||<span style="font-size: 80%; color: #660b0b; font-family: 'Palatino Linotype', 'Book Antiqua', Palatino, serif;">