lesphomework

this is a crazy site for crazy people

Saturday

section 3

select round('event_date','month'),months_between(sysdate,'event_date')
from dual

select (months_between(vacation_date,start_date)*30.5)as"Days"
from dual;

select (months_between('01-JAN-06','31-DEC-06')/12)*365
from dual;

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

select last_day('01-JUN-05')as aliasfrom dual;

select round(months_between(sysdate,birthday)/12,'year')
from dualwhere name='Bob Miller';

select add_months(sysdate,6) as"Appointment"
from dual;

select months_between('27-MAY-06','01-JAN-07')
from dual;

-select next_day('27-MAY-06','friday')as"First Friday"
from dual;

0 Comments:

Post a Comment

<< Home