SELECT * FROM table1 Where aa = #2002-10-10 12:01:20# ================================================================ ◆◆◆ CSDN查询助手,查询方便快捷 ◆◆◆ 下载地址: http://CoolSlob.ifood1.com/Download/CSDNFinder.exe http://CoolSlob.8u8.com/Download/Tools/CSDNFinder.Slob[更名为.exe即可]
to CoolSlob():谢谢!只是得回家才能试。
给你一个时间查询的例子!!!参考一下!!!if RadioButton1.Checked=true then begin with datamodule1.JhdADOQuery do begin close; sql.Clear; sql.Add('select * from 进货表 where 进货日期>='+''''+formatdatetime('yyyy-mm-dd hh:mm:ss',datetimepicker1.datetime)+''''+' and 进货日期<='+''''+formatdatetime('yyyy-mm-dd hh:mm:ss',datetimepicker2.datetime)+''''); open; end; end;
FROM table1
Where aa = #2002-10-10 12:01:20#
================================================================
◆◆◆ CSDN查询助手,查询方便快捷 ◆◆◆ 下载地址:
http://CoolSlob.ifood1.com/Download/CSDNFinder.exe
http://CoolSlob.8u8.com/Download/Tools/CSDNFinder.Slob[更名为.exe即可]
begin
with datamodule1.JhdADOQuery do
begin
close;
sql.Clear;
sql.Add('select * from 进货表 where 进货日期>='+''''+formatdatetime('yyyy-mm-dd hh:mm:ss',datetimepicker1.datetime)+''''+' and 进货日期<='+''''+formatdatetime('yyyy-mm-dd hh:mm:ss',datetimepicker2.datetime)+'''');
open;
end;
end;