类型转换
2020 2003-11-01 05:01:31 SQL SERVER 数据库,其中DAY1为DATETIME类型,长度为8,编译时的错误为:
[Error] Unit1.pas(49): Incompatible types: 'String' and 'TDateTime'
附:
Adoquery1.SQL.Clear
Adoquery1.SQL.Add('select * from data where cast(day1 as datetime) < '''+DateTimePicker1.datetime+''' ');
Adoquery1.open;
另一种办法:
Adoquery1.SQL.Clear
Adoquery1.SQL.Add('select * from data where day1 〈 '''+DateTimePicker1.datetime+''' ');
Adoquery1.open;
错误提示依旧,问题出在哪儿?