NO.1 作者: LCAAA
dim snp As New ADODB.Recordset
s = "SELECT * FROM 表名"
s = s & " WHERE (档案.日期<= convert(datetime," & Format(rq2, "MM-dd-yyyy") & ",102)"
snp.open s,cn
NO.2 作者: DaiLM
select * from tablename where convert(datetime,<日期字段>)=2003-1-1
或者直接判断字符串大小
select * from tablename where <日期字段>=2003-1-1