Community

Round and truncate dates in Oracle

(Bob Watkins) We usually think of rounding as applying only to numeric values: If the digit to the right of where you want to round is 0-4, round down; if itfs 5-9, round up. In Oracle, the ROUND function is used for this: The expression ROUND(12.34, 1) evaluates to 12.3, and the expression ROUND(1

Read More - Register for Free Membership

Tags: