---------------------------简单SQL语句,关于时间查询?----------------------------------

hufanxp 2004-12-31 01:56:11

T1( nProID, BgnTime, EndTime nPre, nLast )
1 2001-9-5 12:12:00 2001-9-5 13:12:00 15 10
2 ...............................

T2 (nUserID userDate, userTime )
1 2001-9-5 1900-01-01 12:13:00
2 2001-9-5 1900-01-01 12:14:00
1 2001-9-6 1900-01-01 12:13:00

nPre,nLast分别表示分钟,int

在T2种用户得时间被分成2个字段 userData为日期 userTime为时间
现在给定一个 nProID,根据T1中得时间stdTime,需要得到
[BgnTime-nPre,2001-9-5 13:12:00+nLast]的时间内,T2中所有nUserID

...全文

218 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

didoleo 2004-12-31

打赏
举报

--先申明一个变量@nProID
select nUserID from
T2
where
cast(userDate+' '+convert(char(10),userTime,108) as datetime)
>=(select dateadd(mi,-nPre,BgnTime) from T1 where nProID=@nProID)
and
cast(userDate+' '+convert(char(10),userTime,108) as datetime)
<=(select dateadd(mi,nLast,EndTime) from T1 where nProID=@nProID)

didoleo 2004-12-31

打赏
举报

select nUserID from
T2
where
cast(userDate+' '+convert(char(10),userTime,108) as datetime)
>=(select dateadd(mi,-nPre,BgnTime) from T1 where nProID=@nProID)
and
cast(userDate+' '+convert(char(10),userTime,108) as datetime)
<=(select dateadd(mi,nLast,EndTime) from T1 where nProID=@nProID)

xueguang 2004-12-31

打赏
举报

declare @A datetime,@B datetime
select @A=dateadd(minure,-nPre,BgnTime),@B=dateadd(minute,nLase,EndTime) from T1 where nProID=?
select nUserID from T2 where userDate+' '+userTime between @A and @B

hufanxp 2004-12-31