數(shù)值函數(shù)

Round

select round(412,-2) from dual;

select round(412.313,2) from dual;

Mod

Trunc

select trunc(412.13,-2) from dual;

日期函數(shù)

Months_between()

select months_between(sysdate,hiredate) from emp;

Add_months()

select add_months(sysdate,1) from dual;

Next_day()

select next_day(sysdate,'星期一') from dual;

Last_day

select last_day(sysdate) from dual;