Database Reference
In-Depth Information
Note:
You may be surprised by a negative precision used with the rounding function.
It simply means that rounding takes place to the left (instead of right) of the decimal
point. The following examples should provide clarification:
•
ROUND (134.4, -1) = 130
•
ROUND (134.4, -2) = 100
•
ROUND (134.4, -3) = 0
•
ROUND (158.6, -1) = 160
•
ROUND (158.6, -2) = 200
•
ROUND (158.6, -3) = 0
12.8.2 Date Functions
Date functions constitute a special group of row functions in Oracle. Oracle has an
internal representation of date, which stores the day, month, year (including century),
hour, minute and second. The default date format is DD-MON-YY. Additionally, Oracle
provides a number of date manipulation functions (Figure
12-8
):
Figure 12-8.
SQL Date Manipulation Functions