如何查询日期SQL语句

Question

form1.ADOQuery1.Close;
  form1.ADOQuery1.SQL.Clear;
  form1.ADOQuery1.SQL.Add('select * from list1 where 日期='+Datetostr(Datetimepicker1.Date)+'  ');
  form1.ADOQuery1.Open;找不到记录....

Answer 1

('select * from list1 where 日期='+Datetostr(Datetimepicker1.Date)+'  '); 
语法错误，你看一下。

Answer 2

'select * from list1 where 日期='''+Datetostr(Datetimepicker1.Date)+''''

Answer 3

如果是sql server
 试试form1.ADOQuery1.SQL.Add('select * from list1 where 日期='''+Datetostr(Datetimepicker1.Date)+''''); 

Answer 4

try
'select * from list1 where 日期='''+Datetostr(Datetimepicker1.Date)+''' '
finally
  showmessage('!');
end;

Answer 5

语法错误，
SQL.Add('select * from list1 where 日期='''+Datetostr(Datetimepicker1.Date)+'''')