O only you Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-29 #2 select * from A where Date1 between :S1 and :S2 S1,S2皆是日期格式的参数！
龙 龙丹 Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-29 #3 select * from qtiddm.dd_obj where 创建时间>=to_Date('2000.01.01','YYYY.MM.DD') and 创建时间<to_Date('2000.03.01','YYYY.MM.DD')
select * from qtiddm.dd_obj where 创建时间>=to_Date('2000.01.01','YYYY.MM.DD') and 创建时间<to_Date('2000.03.01','YYYY.MM.DD')
D dq Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-29 #4 >>字段的范围 如果我没误会的话——SELECT Min(dt) AS mindt, Max(dt) AS maxdt FROM sometable
龙 龙丹 Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-29 #5 select Min(创建时间),Max(创建时间) from qtiddm.dd_obj
H huiboy Unregistered / Unconfirmed GUEST, unregistred user! 2000-12-03 #6 看什么数据库了，条件用'where 日期>=+''#'+'DATE'+'#'
T Tyrael Unregistered / Unconfirmed GUEST, unregistred user! 2000-12-04 #8 format('select * from table where rq>=#%s# and rq<=#%s#',[datetostr(date1),datetostr(date2)]); 可以了吧
format('select * from table where rq>=#%s# and rq<=#%s#',[datetostr(date1),datetostr(date2)]); 可以了吧
