返回一个数字反余弦值
SQL> select cosh() from dual;
COSH()
EXP
返回一个数字e的n次方根
SQL> select exp()exp() from dual;
EXP() EXP()
FLOOR
对给定的数字取整数
SQL> select floor() from dual;
FLOOR()
LN
返回一个数字的对数值
SQL> select ln()ln()ln() from dual;
LN() LN() LN()
LOG(nn)
返回一个以n为底n的对数
SQL> select log()log() from dual;
LOG() LOG()
MOD(nn)
返回一个n除以n的余数
SQL> select mod()mod()mod() from dual;
MOD() MOD() MOD()
POWER
返回n的n次方根
SQL> select power()power() from dual;
POWER() POWER()
ROUND和TRUNC
按照指定的精度进行捨入
SQL> select round()round()trunc()trunc() from dual;
ROUND() ROUND() TRUNC() TRUNC()
SIGN取数字n的符号大于返回小于返回等于返回 SQL> select sign()sign()sign() from dual;
SIGN() SIGN() SIGN()
SIN
返回一个数字的正弦值
SQL> select sin() from dual;
SIN()
SIGH
返回双曲正弦的值
SQL> select sin()sinh() from dual;
SIN() SINH()
SQRT
返回数字n的根
SQL> select sqrt()sqrt() from dual;
SQRT() SQRT()
TAN
返回数字的正切值
SQL> select tan()tan() from dual;
TAN() TAN()
TANH
返回数字n的双曲正切值
SQL> select tanh()tan() from dual;
TANH() TAN()
TRUNC
按照指定的精度截取一个数
SQL> select trunc() trunctrunc() from dual;
TRUNC TRUNC()
ADD_MONTHS
增加或减去月份
SQL> select to_char(add_months(to_date(yyyymm))yyyymm) from dual;
TO_CHA
SQL> select to_char(add_months(to_date(yyyymm))yyyymm) from dual;
TO_CHA
LAST_DAY
返回日期的最后一天
SQL> select to_char(sysdateyyyymmdd)to_char((sysdate)+yyyymmdd) from dual;
TO_CHAR(SY TO_CHAR((S
SQL> select last_day(sysdate) from dual;
LAST_DAY(S
月
MONTHS_BETWEEN(datedate)
给出datedate的月份
SQL> select months_between(月月) mon_between from dual;
MON_BETWEEN
SQL>selectmonths_between(to_date(yyyymmdd)to_date(yyyymmdd))
mon_betw from dual;
MON_BETW
NEW_TIME(datethisthat)
给出在this时区=other时区的日期和时间
SQL> select to_char(sysdateyyyymmdd hh:mi:ss) bj_timeto_char(new_time (sysdatePDTGMT)yyyymmdd hh:mi:ss) los_angles from dual;
BJ_TIME LOS_ANGLES
:: ::
NEXT_DAY(dateday)
给出日期date和星期x之后计算下一个星期的日期
SQL> select next_day(月星期五) next_day from dual;
NEXT_DAY
月
