与 与你同行 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-22 #1 例如:表中有 RQ(日期)字段(日期型),如何选择日期 从2001-9-1 到2001-10-1 的所有记录?
雪 雪中漫步 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-22 #2 select * from tablename where rq between :rq1 and rq2; parameters[0].asdatetime:=strtodate('2001-9-1'); parameters[1].asdatetime:=strtodate('2001-10-1'); open;
select * from tablename where rq between :rq1 and rq2; parameters[0].asdatetime:=strtodate('2001-9-1'); parameters[1].asdatetime:=strtodate('2001-10-1'); open;
S seager Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-22 #3 select * from tablename where rq between #2002-09-01# and #2002-09-30#;
与 与你同行 Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-29 #5 谢谢雪中漫步,和另外两位, 接受答案,给分晚了,不好意思