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
 
Search WWH ::




Custom Search