C# Oracle to_date 日期型 参数传值 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"";}