C#操作oracle，date字段，使用參數傳值
例子一，獲取三小時前的記錄
publicstaticDataTableQuery(){conststringsSql="selectxh,lsh,namefromtablewheregxsj>to_date(:gxsj,'yyyy-MM-ddHH24:mi:ss')";OracleParameter[]parameters={newOracleParameter(":gxsj",OracleType.VarChar,10)};parameters[0].Value=DateTime.Now.AddHours(-3).ToString("yyyy-MM-ddHH")+":00:00";returnDBUtility.DbHelperOra.Query(sSql,parameters).Tables[0];}例子二，獲取大于當前時間的記錄
publicstaticstringGetHphm(stringsClsbdh){conststringsSql="selectnamefromtablewheresj>to_date(:yxsj,'yyyy-MM-dd')";OracleParameter[]paramters={newOracleParameter("sj",OracleType.VarChar,10)};paramters[0].Value=DateTime.Now.ToString("yyyy-MM-dd");using(varmReader=DbHelperOra.ExecuteReader(sSql,paramters)){if(mReader.Read()){returnmReader["name"].ToString();}}return"";}新聞熱點
疑難解答
