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);
阅读全文
摘要：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
阅读全文
摘要：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',&#
阅读全文
