shortformat:='yyyy-mm-dd'; select * from db where rq=convert(smalldate,''2002-02-02'')试试
shortformat:='yyyy-mm-dd'; select * from db where rq=convert(smalldate,''2002-02-02'')试试 不支持!
试试 select * from db where rq='2/2/2002'
直接带参数不就可以了么? with Query1 do begin Close; Sql.Clear Sql.Add('select * from db.db where rq=:SetDate'); ParamByName('SetDate').AsDateTime := Now; Open; end;
下面这个一定可以,不可以就是你的错。 query1.sql.Add('select * from "db.db" where rq=:rq'); query1.ParamByName('rq').AsDateTime := EncodeDate(2002, 2, 2); query1.open;
下面这个一定可以,如果不可以,那就是你的问题。 query1.sql.Add('select * from "db.db" where rq=:rq'); query1.ParamByName('rq').AsDateTime := EncodeDate(2002, 2, 2); query1.Open;
paradox中日期格式为:"MM/DD/YYYY" (带双引号)query1.sql.Add('select * from db.db where rq="2/2/2002"');
select * from db where rq=convert(smalldate,''2002-02-02'')试试
select * from db where rq=convert(smalldate,''2002-02-02'')试试
不支持!
select * from db where rq='2/2/2002'
with Query1 do
begin
Close;
Sql.Clear
Sql.Add('select * from db.db where rq=:SetDate');
ParamByName('SetDate').AsDateTime := Now;
Open;
end;
query1.sql.Add('select * from "db.db" where rq=:rq');
query1.ParamByName('rq').AsDateTime := EncodeDate(2002, 2, 2);
query1.open;
query1.sql.Add('select * from "db.db" where rq=:rq');
query1.ParamByName('rq').AsDateTime := EncodeDate(2002, 2, 2);
query1.Open;