Oracle MONTHS_BETWEEN ,NEW_TIME Functions
MONTHS_BETWEEN(end_date, start_date)
Number of months between the 2 dates (integer)
select MONTHS_BETWEEN('10-DEC-08','10-MAR-08') from dual
Result:9
select MONTHS_BETWEEN('01-DEC-08','10-MAR-08') from dual
Result:8.70967741935483870967741935483870967742
NEW_TIME(date, zone1, zone2)
Convert between GMT and US time zones (but not CET)
NEXT_DAY(date,day_of_week)
'01-OCT-08','Monday' will return the next Mon after 01 Oct
select NEXT_DAY('14-Mar-2008','Monday') from dual
Result : 17-MAR-08
|
|
Page 1
|
| 
