日期函数-big.data.analytics.with.spark

4.2、数值函数Round select round(412,-2) from dual; select round(412.313,2) from dual; Mod Trunc select trunc(412.13,-2) from dual; 4.3、日期函数Months_between() select months_between(sysdate,hiredate) from emp; Add_months() select add_months(sysdate,1) from dual;