Oracle_函数_02

/* 与ROUND相同，只是没有四舍五入 */
int TRUNC(Number)
Number TRUNC(Number, int)
---------
double EXP(double)
double LN(double)
double LOG(double)
double POWER(double, double)
double SQRT(double)
int SIGN(Number)


int MOD(int, int)
SELECT MOD(2, 3) FROM dual;  /* 2 */
SELECT MOD(12, 7) FROM dual;  /* 5 */
long COUNT(*)
long COUNT([ALL | DISTINCT] List<T> col)


Object NVL(Object colVal, Object reVal)


Date ADD_MONTHS(Date, int) /* 增减(正负) */
示例:
SELECT ADD_MONTHS(TO_DATE('2013-04-27', 'yyyy-MM-dd'), 1) FROM dual;  /* 2013/5/27 */
SELECT ADD_MONTHS(TO_DATE('2013-04-27', 'yyyy-MM-dd'), -2) FROM dual;  /* 2013/2/27 */


Date LAST_DAY(Date) /* 返回日期对象（所在月）最后一天 */
示例:
SELECT LAST_DAY(TO_DATE('2013-04-27', 'yyyy-MM-dd')) FROM dual;  /* 2013/4/30 */


Number MONTHS_BETWEEN(Date, Date) /* 返回日期对象之间的月份数 */
示例:
/* 如果要获取月份数，还要将其转成整数 */
SELECT MONTHS_BETWEEN(TO_DATE('2013-04-05', 'yyyy-MM-dd'), TO_DATE('2013-07-12', 'yyyy-MM-dd')) FROM dual;  /* -3.2258064516129 */


Date NEW_TIME(Date, String time_zone_this, String time_zone_that)