ADOQuery的时间参数问题,在线等...
我用以下方法时,怎么总是查询不到数据
sql语句如下:
select * from table1
where scsj between To_date(to_char(:date1),'YYYY-MM-DD hh24:mi:ss')
and to_date(to_char(:date2),'YYYY-MM-DD hh24:mi:ss')
procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery1.Close;
adoquery1.Parameters.Items[0].Value:=DateTimeToStr(DateTimePicker1.DateTime);
adoquery1.Parameters.Items[1].Value:=DateTimeToStr(DateTimePicker2.DateTime);
adoquery1.Open;
end;