03 2013 档案

摘要://保留小数点后面两位Math.Round(string string1,int num1,MidpointRounding.AwayFromZero);注:string string1: 要四舍五入的内容;intnum :保留的位数;例:保留两位。double month12_Day = Math.Round(Convert.ToDouble(newFormula[11].ToString()) / 31, 2, MidpointRounding.AwayFromZero); 阅读全文
posted @ 2013-03-15 14:43 Mr zhao 阅读(288) 评论(0) 推荐(0) 编辑
摘要:BEGINDELETE FROM SYSROLEOPENR WHERE ROLEID = 2;INSERT INTO SYSROLEOPENR (PKID, ROLEID, OPERID) SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL, '2' ROLEID, OPERID FROM SYSMODULEOPER WHERE OPERCODE = '300090010';INSERT INTO SYSROLEOPENR (PKID, ROLEID, OPERID) SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL 阅读全文
posted @ 2013-03-14 16:44 Mr zhao 阅读(2065) 评论(0) 推荐(0) 编辑
摘要:oracle日期相减收藏:http://hi.baidu.com/echolovejose/item/2bf4b35af54204cdd2e10c77--MONTHS_BETWEEN(date2,date1)给出date2-date1的月份SQL> select months_between('19-12月-1999','19-3月-1999') mon_between from dual;MON_BETWEEN----------- 9SQL>select months_between(to_date('2000.05.20',&# 阅读全文
posted @ 2013-03-14 11:23 Mr zhao 阅读(1332) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示