博文
oracle substr()函数的用法(2006-12-08 18:19:00)
摘要：格式：substr(string,startindex,length)
示例：select * from tbl_faxreceivelist where substr(starttime,4,4)='Dec' and (to_number(substr(starttime,8,3))>=1 and to_number(substr(starttime,8,3))<=7) or (substr(starttime,6,2)='12' and to_number(substr(starttime,9,3))>=1 and to_number(substr(starttime,9,3))<=7)......
ORACLE的取整方法(2006-10-12 18:02:00)
摘要：round()四舍五入，如：
round(3.55)=4
round(3.12)=3
trunc()只取整数部分，如：
trunc(3.55)=3
trunc(3.12)=3......