LESSON 3

1.select id,name,round(months_between(sysdate,event_date),0)
from d_events

2.select round(months_between('31-dec-06','01-jan-06')*30.5,0)
from dual

3.select round(months_between('31-dec-06','01-jan-06')*30.5,0)
from dual

4.select trunc(round(sysdate,'month'),'month')as alias,trunc(round(sysdate,'year'),'year')as alias
from dual;

5.select last_day('01-JUN-05')AS "JUNE"
FROM DUAL

6.select round(months_between(sysdate,birthday)/12,'year')
from dual
where name='Bob Miller';


7.SELECT ADD_MONTHS(SYSDATE,6)AS"Appointment"
FROM DUAL

8.select LAST_DAY('01-FEB-06')AS "Deadline"
from dual

9.select round(months_between('01-jan-07','27-aug-06'),0)as "BIRTHDAY DAY"
from dual

10.select next_day('27-aug-06','FRIDAY')AS "First Friday"
from dual