SQL的Between...And...使用问题!
在定义时间后,在SElect语句中如何在Between....And....中使用!!
syear=request("s-year")
smonth=request("s-month")
sdate=request("s-date")
eyear=request("e-year")
emonth=request("e-month")
edate=request("e-date")
sdata=smonth&"/"&sdate&"/"&syear
edata=emonth&"/"&edate&"/"&eyear
select sum(cc_confirm) from zonghe where cc_date between ????? and ???????