Oracle培训教程：数据函数和日期单行函数语句

数值函数

Round

select round(412,-2) from dual;

select round(412.313,2) from dual;

Mod

Trunc

select trunc(412.13,-2) from dual;

日期函数

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;