sql查询求助

[蕾丝凶兆]

我有个表 结构是:
AttendID userID beginTime endTime
1 2 2010-10-10 11:00:00 2010-10-10 12:00:00
2 2 2010-10-11 11:00:00 2010-10-11 12:00:00
3 2 2010-10-12 11:00:00 2010-10-12 12:00:00
4 2 2010-10-14 11:00:00 2010-10-14 12:00:00
大概是这样的结构
我想要查询
2010-10-10到2010-10-14 之间的记录
sql语句是这样写的
1.
select * from attendance where userID=2 and beginTime > 2010-10-10 and beginTime < 2010-10-14
2.
select * from attendance where userID=6 and beginTime between 2010-10-10 and 2010-10-19
两条语句都试过，都是空表.我的语句有什么问题？？在线等答案~~~~

[jacklinq]

时间表达式不对吧,要用#2008-02-02#试试

[让我带你走]

应该是没有加单引号引起来
[code=SQL]
1.
select * from attendance where userID=2 and beginTime > '2010-10-10 and' beginTime < '2010-10-14'
[code]

[szhda4le]

第二条语句 userId不应该是2吗？

[szhda4le]

不加单引号应该直接就报错了吧

[仙儿]

select * from attendance where userID=2 and beginTime between 2010-10-10 and 2010-10-19



试试

[misswangjinfeng]

首先确保有这样的记录
=的要排除吗？
加个括号试试。


select * from attendance where userID=2 and
(beginTime > 2010-10-10 and beginTime < 2010-10-14)

[antiking]

2楼正解，这个问题问过很多次了。

[Sun_Thinking]

select * from attendance
where userID='2' and beginTime > '2010-10-10 11:00:00' and beginTime < '2010-10-14 11:00:00'

结果：
2 2 2010-10-11 11:00:00.000 2010-10-11 12:00:00.000
3 2 2010-10-12 11:00:00.000 2010-10-12 12:00:00.000

[dengjingjian628]

是时间表达式写错了

[yucuihaimeng]

LZ的ＳＱＬ语句就在于没有给时间加单引号

[wubudang]

select * from attendance
where userID='2' and beginTime >='2010-10-10' and beginTime < '2010-10-15'

[min420625]

时间格式改下就可以了，同楼上的！