asp如何查询两个时间之间的数据

2025-02-27 08:15:47
推荐回答(3个)
回答1:

sql="select * from [record] where inTime between #2007-12-01# and #2007-12-30#"相应的换成变量就可以了

回答2:

sql="select * from [record] where inTime between #2007-12-01# and #2007-12-30#"变更一下就行了

回答3:

sql用between andselect * from 表where time between 2009-11-1 00:00:00 and 2009-11-9 00:00:00