sql.clear; sql.add('select * from tablename where datefield between :BDate and :EDate');parambyname('BDate').AsDate := currentdate; parambyname('EDate').AsDate := currentdate - 7;
with Query1 do begin Close; SQL.Clear; SQL.Add ('select field1 from ATable'); SQL.Add ('where TimeField = :time'); ParamByName('time').AsDateTime := FormatDateTime ('yyyy-mm-dd', ADateTimeTypeValue);//FormatDateTime()格式化成你所需要的日期格式,参考Delphi的在线帮助。 Prepare; try Open; .... .... finally Close; end; end;
Query.active:=false; Query.SQL.clear; Query.SQL.Add('Select Clo From Table where date between '+''''+DateToStr(BeginDate)+''''+' and '+''''+ DateToStr(EndDate)+''''); Query.Active:=true;
sql.add('select * from tablename where datefield between :BDate and :EDate');parambyname('BDate').AsDate := currentdate;
parambyname('EDate').AsDate := currentdate - 7;
begin
Close;
SQL.Clear;
SQL.Add ('select field1 from ATable');
SQL.Add ('where TimeField = :time');
ParamByName('time').AsDateTime := FormatDateTime ('yyyy-mm-dd', ADateTimeTypeValue);//FormatDateTime()格式化成你所需要的日期格式,参考Delphi的在线帮助。
Prepare;
try
Open;
....
....
finally
Close;
end;
end;
Query.SQL.clear;
Query.SQL.Add('Select Clo From Table where date between '+''''+DateToStr(BeginDate)+''''+' and '+''''+ DateToStr(EndDate)+'''');
Query.Active:=true;
DateToStr() 将日期格式转换为字符串
Time() 返回当前的时间
TimeToStr() 将时间格式转换为字符串
chutian(kiss you) 和wangchinaking(Deemon)的思路跟我想的一样,
但行不通。SayForever(恒) 的意见没有问题。
此贴到此为止。请各位注意接分。