我写的sql语句不能执行,数据库里是'01-2-27'的内容,我的sql语句是'select * from info where inputtime>'01-1-1'怎么不对?
var mydate:tdate; begin query1.sql.clear; query1.sql.add('select * from info where inputtime>:date'); query1.ParamByName('date').AsDate:=mydate; query1.active:=true; end;
用 'select * from info where inputtime>'+floattostr(int(日期))
begin
query1.sql.clear;
query1.sql.add('select * from info where inputtime>:date');
query1.ParamByName('date').AsDate:=mydate;
query1.active:=true;
end;