Database Reference
In-Depth Information
umn is divided by the average number of days per month (30.44). The two
values Months-1 and Months-2 are very close but not identical. This is a
rather odd example, but Figure 9.9 shows the result.
SELECT SESSION_DATE
, ADD_MONTHS(SESSION_DATE,3) "Plus 3 Months"
, ROUND(SESSION_DATE,'Month') "Round off"
, MONTHS_BETWEEN(SYSDATE,DUE_DATE) "Months-1"
, (SYSDATE-DUE_DATE)/30.44 "Months-2"
FROM STUDIOTIME
WHERE ROWNUM < 15;
The next section examines datatype conversion functions.
Figure 9.9
Date Functions Use
Oracle Database
10g's Standard
Date Output
Format.
