如果你使用ACCESS数据库要在日期前加#号,否则不要.
例如查询ACCESS
AdoQuery1->Close();
AdoQuery1->SQL->Clear();
AdoQuery1->SQL->Add("select * from tablename where fieldname = #1999-02-01#");
AdoQuery1->ExecSQL();
例如查询ACCESS
AdoQuery1->Close();
AdoQuery1->SQL->Clear();
AdoQuery1->SQL->Add("select * from tablename where fieldname = #1999-02-01#");
AdoQuery1->ExecSQL();
我知道用BETWEEN AND,但我不知道具体格式
select * from TableName
where date<=Date1 and date>=Date2;
或者:
select * from TableName
where date between Date2 and Date1//小的在前大的在后,才能查出结果
AdoQuery1.Close();
AdoQuery1.SQL.Clear();
AdoQuery1.SQL.Add('select * from Table where date between '+ '''' + DatetimeToStr(Begindate) + '''' + ' and ' + '''' + DatetimeToStr(Enddate) + '''')
(加双银号)如果是paradox
则 sql.add('between :date1 and :date2);
parambyname('date1').asdate:=1999-09-09;
parambyname('date2').asdate:=2000-09-09;