我用SQL对时间字段进行查询时,却查不出,或查不到,请问要如何解决啊??
比如:
sql.add('select * from salary where 时间='+''''+text1.text+'''');
我的‘时间’字段是DATE型。多谢!!!!!!!
比如:
sql.add('select * from salary where 时间='+''''+text1.text+'''');
我的‘时间’字段是DATE型。多谢!!!!!!!
sql.add('select * from salary where 时间=''#'+text1.text+'#''');
form1.ADOQuery1.Parameters.ParamByName('s1').value:=strtodate(edit1.text);
sql.add('select * from salary where DateDiff(day,时间,Cast('+''''+text1.text+''''+' as DateTime))=0');
var
dat:date
bein
dat:=strtodate(text1.text);
sql.add('select * from salary where 时间=dat);
perpare;
open;
end;