关于sql的问题

[kofoun]

有一表如下:
employee
字段
employee_id(工号),employee_name(姓名),starttime(请假开始时间), endtime(请假结束时间)
001 李工 2008-1-1 2008-1-4
002 黄工 2008-1-3 2008-3-3
003 谢工 2008-1-3 2008-1-5

我想查询starttime在:2008-1-3并且endtime在2008-1-3的记录
理论得出的结果应是:
001 李工 2008-1-1 2008-1-4
002 黄工 2008-1-3 2008-3-3
003 谢工 2008-1-3 2008-1-5

因为以上三人都是当在1-3之间有休假记录
用sql怎么实现??

[昵称被占用了]

select * from employee 
 where '2008-1-3' between starttime and endtime

[子陌红尘]

declare @starttime datetime,@endtime datetime
set @starttime='2008-1-3'
set @endtime  ='2008-1-3'

select * from employee where (@starttime between starttime and endtime) and (@endtime between starttime and endtime)

[昵称被占用了]

or:

select * from employee 
where starttime>='2008-1-3'
and endtime<='2008-1-3'

[wlinglong]

Select * From employee Where starttime <= @end and endtime >= @end

[sweetweiwei]

select employee_id,employee_name,starttime,endtime
from employee
where starttime<= '2008-1-3' or endtime >= '2008-1-3'

[kofoun]

没有一个答案是对的,请大家做一测试就知道结果同我预期的不一样

[kofoun]

也就是说在1-3这个时间当中,有记录的都应全部找出来

[昵称被占用了]

检查你的数据类型吧

最好是日期的东西你就用datetime类型，否则很难交流

[kofoun]

都是日期字段

[evoloyeu]

read book or search online

[-狙击手-]

declare @starttime datetime,@endtime datetime
set @starttime='2008-1-3'
set @endtime  ='2008-1-3'

select * 
from employee 
where datediff(d,@starttime ,starttime) = 0
      and datediff(d,@endtime ,starttime) = 0

[sweetweiwei]

create table employee
(
employee_id char(3),
employee_name nvarchar(10),
starttime datetime,
endtime datetime
)
insert into employee
select
'001',N'李工', '2008-1-1','2008-1-4' union
select
'002',N'黄工', '2008-1-3','2008-3-3' UNION
select
'003',N'谢工', '2008-1-3','2008-1-5'

select employee_id,employee_name,starttime,endtime
from employee
where starttime<= '2008-1-3' or endtime >= '2008-1-3'
结果
employee_id employee_name starttime endtime
----------- ------------- ----------------------- -----------------------
001 李工 2008-01-01 00:00:00.000 2008-01-04 00:00:00.000
002 黄工 2008-01-03 00:00:00.000 2008-03-03 00:00:00.000
003 谢工 2008-01-03 00:00:00.000 2008-01-05 00:00:00.000

(3 row(s) affected)
--不是你要的吗