select * from t_aqjcjbtj where datediff(d,ftjrq,"&start_date&")=0'''查询start_date当天的
sql = sql & " where DATENAME('yyyy-mm-dd',ftjrq)='"& start_date & "'"
多写一个
sql = sql & " where ftjrq between '" & start_date & " 00:00:' and '" & start_date & " 23:59:59'"