orcale里按日期查询的问题!!!在线等,解决马上给分!!!
ADOAmQuery.SQL.Text := ' select Name from wmark.alarm_state ' +
' where mediation_time >=
to_date('+Datestr+', ''YYYY/MM/DD HH24:MI:ss'') order by mediation_time ';
ADOAmQuery.Open; //其中Datestr=2003-05-21 12:11:02
请各位看一下,我这么写有什么问题,老是会报错:提供不一致或不完整的咨讯导致物件被拒