系统时间SQL: Select GetDate() as DateTime查询纪录SQL with adoQuery do begin close; sql.clear; sql.add('select * from PDM where daytime=:DTime'); Parameters.ParamByName('DTime').AsDatetime=保存时间的参数 Open; end;
系统时间date var XT,GD : Tdatetime;XT:= date;给定时间用TDateTimePicker控件 with adoQuery do begin close; sql.clear; sql.add('select * from PDM where daytime between :stratdate and :enddate'); ParamByName('stratdate').asdate:= DateTimePicker1.date; ParamByName('enddate').asdate:= XT; Prepare; Open; end;
with adoQuery do
begin
close;
sql.clear;
sql.add('select * from PDM where daytime=:DTime');
Parameters.ParamByName('DTime').AsDatetime=保存时间的参数
Open;
end;
var
XT,GD : Tdatetime;XT:= date;给定时间用TDateTimePicker控件
with adoQuery do
begin
close;
sql.clear;
sql.add('select * from PDM where daytime between :stratdate and :enddate');
ParamByName('stratdate').asdate:= DateTimePicker1.date;
ParamByName('enddate').asdate:= XT;
Prepare;
Open;
end;