数据库中利用日期查询请教个位高手

[pcwanli]

我的查询语句是这样的怎么就是不对：
set rs = server.createobject("adodb.recordset")
rs.CursorLocation = 3
rs.Open "select * from table where subdate between #2002-01-01# and #2003-12-30#",conn,2
问题好象就是出在SQL语句中,数据库是SQL SERVER,subdate字段的类型是datetime类型，此类型有日期和时间如2003-9-25 10:09:26。各位高手帮忙，怎样查询日期在2002-01-01到2003-12-30之间的数据，是“#”符号不对，还是类型的问题，还是什么其他的问题？先谢谢各位了。

[gshope]

select * from table where subdate>'2002-01-01' and subdate<dateadd(dd,1,'2003-12-30')

[shijian58]

输出你的sql语句到数据库里试一下不久知道了吗

[lovehwq21]

"select * from table where subdate >='2002-01-01 00:00:00' and subdate<='2003-12-30 23:59:59'"

[say1no2]

"select * from table where subdate > '2002-01-01' and subdate < '2003-12-30'"

[shiyudir12]

"select * from table where subdate >=#2002-01-01 00:00:00# and subdate<=#2003-12-30 23:59:59#"

[1蓝天1]

我的是这样写的，用起来很好用呀！试试吧
sql = "select * from gzwt where account='"&account&"' and wt_time=#"×&"#"

[1蓝天1]

在两个日期之间的话只要加个AND在把=号一改就可了

[zhanghao5188]

rs.open "select * from biao where subdate >='2002-01-01 00:00:00' and subdate<='2003-12-30 23:59:59'"，conn,1,3 在sql 中


rs.Open "select * from biao where subdate between #2002-01-01# and #2003-12-30#",conn,1,3 在access中没有问题！

[angeb]

set rs = server.createobject("adodb.recordset")
sql= "select * from table where subdate between '2002-01-01' and '2003-12-30' "
rs.Open sql,conn,1,1

[angeb]

#是access数据库用的