求sql 语句(100分)

var t: tdatetime;<br>begin<br>&nbsp; &nbsp; t := m.fieldbyname('最后操作日期').AsDateTime;// t is 2003-02-12 3:34:09 <br>&nbsp; &nbsp; m.Close;<br>&nbsp; &nbsp; m.CommandText := 'select &nbsp;* from teacher2 ' +<br>&nbsp; &nbsp; &nbsp; &nbsp; ' where &nbsp;最后操作日期&gt;' +'#'+datetimetostr(t)) +'#'<br>&nbsp; &nbsp; &nbsp; &nbsp; ' order by 最后操作日期 ';<br>&nbsp; &nbsp; m.Open;<br>end;<br>////////////// 数据库是：access ,为什么对长日期的出来不正确呢？

var t: tdatetime;<br>begin<br>&nbsp; &nbsp; t := m.fieldbyname('最后操作日期').AsDateTime;// t is 2003-02-12 3:34:09 &nbsp; &nbsp; <br>&nbsp; &nbsp; m.Close;<br>&nbsp; &nbsp; m.CommandText := 'select &nbsp;* from teacher2 ' +<br>&nbsp; &nbsp; &nbsp; &nbsp; ' where &nbsp;(cdate(最后操作日期)&gt;cdatedate)) order by 最后操作日期 ';<br>&nbsp; &nbsp; m.Parameters.ParamValues['date'] :=<br>&nbsp; &nbsp; &nbsp; &nbsp;FormatDateTime('YYYY-MM-DD hh:nn:ss', t);<br>&nbsp; &nbsp; m.Open;<br>end;<br><br>DELPHI把时间里的“：”及后面的值当成了变量参数来处理，所以执行不成功。<br>改成带参数的方式再赋值就可以。[]

这个问题处理过，原数据库发过来。QQ:136676485

把时间部分抹去就正确了