with query do
begin
close;
sql.Clear;
sql.Add('select * from content.dbf ');
sql.add('where sdate >= '+datetostr(dfirstdate));
sql.add('and sdate<='+datetostr(dlastdate));
open;
end;
begin
close;
sql.Clear;
sql.Add('select * from content.dbf ');
sql.add('where sdate >= '+datetostr(dfirstdate));
sql.add('and sdate<='+datetostr(dlastdate));
open;
end;
FormatDateTime('MM/DD/YYYY',dfirstdate)来转换;
DateToStr是按照你机器的配置来转换日期的.
而本地SQL只识别 'MM/DD/YYYY'这种格式.
我觉得不是如此,
以前碰到此类问题,我一直用TQuery的Params加输入参数来解决的
就没有问题!
不知有和高见?
begin
close;
sql.Clear;
sql.Add('select * from content.dbf ');
sql.add('where sdate between '''+formatdatetime('yyyy-mm-dd',dfirstdate)'''+' and '''+formatdatetime('yyyy-mm-dd',dlastdate)+'''');
open;
end;