'数据库为SQL: select * from 表名 where 出城时间 between '2009-5-15 00:00:00' and '2009-5-15 23:59:59' '数据库为ACCESS: select * from 表名 where 出城时间 between #2009-5-15 00:00:00# and #2009-5-15 23:59:59#
如果是ACCESS,可以使用 SELECT * FROM 表 WHERE 日期 BETWEEN #2005-5-15 00:00:00# AND #2005-5-15 23:59:59#
2009-5-15是我在textbox中输入的东西,可以将#2009-5-15 00:00:00# and #2009-5-15 23:59:59#中的2009-5-15换成text1.text吗?
数据库为SQL: select * from 表名 where 出城时间 between '"& text1.text &" 00:00:00' and '"& text1.text &" 23:59:59' '数据库为ACCESS: select * from 表名 where 出城时间 between #"& text1.text &" 00:00:00# and #"& text1.text &" 23:59:59#
如果是ACCESS,也可以使用 SELECT * FROM 表 WHERE left(日期,10) = #2005-5-15#
select * from 表名 where 出城时间 between '2009-5-15 00:00:00' and '2009-5-15 23:59:59'
'数据库为ACCESS:
select * from 表名 where 出城时间 between #2009-5-15 00:00:00# and #2009-5-15 23:59:59#
SELECT * FROM 表 WHERE 日期 BETWEEN #2005-5-15 00:00:00# AND #2005-5-15 23:59:59#
select * from 表名 where 出城时间 between '"& text1.text &" 00:00:00' and '"& text1.text &" 23:59:59'
'数据库为ACCESS:
select * from 表名 where 出城时间 between #"& text1.text &" 00:00:00# and #"& text1.text &" 23:59:59#
SELECT * FROM 表 WHERE left(日期,10) = #2005-5-15#