Oracle 函数大全[字符串函数，数学函数，日期函数]第1/4页
31.sigh
返回双曲正弦的值
sql> select sin(20),sinh(20) from dual;
sin(20) sinh(20)
--------- ---------
.91294525 242582598
32.sqrt
返回数字n的根
sql> select sqrt(64),sqrt(10) from dual;
sqrt(64) sqrt(10)
--------- ---------
8 3.1622777
33.tan
返回数字的正切值
sql> select tan(20),tan(10) from dual;
tan(20) tan(10)
--------- ---------
2.2371609 .64836083
34.tanh
返回数字n的双曲正切值
sql> select tanh(20),tan(20) from dual;
tanh(20) tan(20)
--------- ---------
1 2.2371609
35.trunc
按照指定的精度截取一个数
sql> select trunc(124.1666,-2) trunc1,trunc(124.16666,2) from dual;
trunc1 trunc(124.16666,2)
--------- ------------------
100 124.16
36.add_months
增加或减去月份
sql> select to_char(add_months(to_date('199912','yyyymm'),2),'yyyymm') from dual;
to_cha
------
200002
sql> select to_char(add_months(to_date('199912','yyyymm'),-2),'yyyymm') from dual;
to_cha
------
199910
37.last_day
返回日期的最后一天
sql> select to_char(sysdate,'yyyy.mm.dd'),to_char((sysdate)+1,'yyyy.mm.dd') from dual;
to_char(sy to_char((s
---------- ----------
2004.05.09 2004.05.10
sql> select last_day(sysdate) from dual;
last_day(s
----------
31-5月 -04
38.months_between(date2,date1)
给出date2-date1的月份
sql> select months_between('19-12月-1999','19-3月-1999') mon_between from dual;
mon_between
-----------
9
sql>selectmonths_between(to_date('2000.05.20','yyyy.mm.dd'),to_date('2005.05.20','yyyy.mm.dd')) mon_betw from dual;
mon_betw
---------
-60
39.new_time(date,'this','that')
给出在this时区=other时区的日期和时间
sql> select to_char(sysdate,'yyyy.mm.dd hh24:mi:ss') bj_time,to_char(new_time
2 (sysdate,'pdt','gmt'),'yyyy.mm.dd hh24:mi:ss') los_angles from dual;
bj_time los_angles
------------------- -------------------
2004.05.09 11:05:32 2004.05.09 18:05:32
40.next_day(date,'day')
给出日期date和星期x之后计算下一个星期的日期
sql> select next_day('18-5月-2001','星期五') next_day from dual;
next_day
----------
25-5月 -01
3
如对本文有疑问，
点击进行留言回复！！
我要评论
网友评论