rstemp.Open "SELECT * FROM sb_spxx WHERE NSRSBH = '"+danwei_mingcheng+"' and kprq>=to_date('"&search_date_begin1&"','yyyy-mm-dd hh24:mi:ss') and kprq <=to_date('"&search_date_end1&"','yyyy-mm-dd hh24:mi:ss'),conntemp,1"
也可以用to_char, 把数据库里的日期型转成字符串型比较 比如: rstemp.Open "SELECT * FROM sb_spxx WHERE NSRSBH = '"+danwei_mingcheng+"' and to_char(kprq,'yyyy-mm-dd')>=to_date('" & search_date_begin1 &"' and to_char(kprq ,'yyyy-mm-dd')<='" & search_date_end1 & "'"
比如:
rstemp.Open "SELECT * FROM sb_spxx WHERE NSRSBH = '"+danwei_mingcheng+"' and to_char(kprq,'yyyy-mm-dd')>=to_date('" & search_date_begin1 &"' and to_char(kprq ,'yyyy-mm-dd')<='" & search_date_end1 & "'"