2个时间查询:FromTime:18:00:00 ToTime:22:00:00
"Update Tables Set SiteStatus=1 Where TableName In (Select TableName From tableBook " & _
" Where BookDate='" & Format(DTPicker3.Value, "yyyy-mm-dd") & "' and " & _
" '" & Format(DTPicker5.Value, "hh:mm:ss") & "' Not between FromTime and Totime " & _
" Or '" & Format(DTPicker6.Value, "hh:mm:ss") & "' Not between FromTime and Totime and status=7)"这种只能查询到 时间交集(13-19) ,查询不到时间的子集 (19-20)。
请问下怎么查询
"Update Tables Set SiteStatus=1 Where TableName In (Select TableName From tableBook " & _
" Where BookDate='" & Format(DTPicker3.Value, "yyyy-mm-dd") & "' and " & _
" '" & Format(DTPicker5.Value, "hh:mm:ss") & "' Not between FromTime and Totime " & _
" Or '" & Format(DTPicker6.Value, "hh:mm:ss") & "' Not between FromTime and Totime and status=7)"这种只能查询到 时间交集(13-19) ,查询不到时间的子集 (19-20)。
请问下怎么查询
Or '21:00:00' Not between FromTime and Totime) 加个括号试下,还是不太了解需求。
开始时间<=totime and 结束时间>=fromtime
就可以
就符合条件(项目这种需求很多)
所以只要 开始时间<=totime and 结束时间>=fromtime 就可以了当然如果LZ不是这个意思就当我没说……
我现在要更新的是 在(DTPicker5-DTPicker6)时间内,更新SITESTATUS=1。比如我存储的2个时间为FROMTIME 18:00:00 和 TOTIME 22:00:00 那么只要DTPicker5和DTPicker6的时间段在18-22就可以了。就是求一个空集。
SiteStatus=1
Where TableName In (
Select TableName From tableBook
Where BookDate='2010-05-13' and
('DTPicker5' between FromTime and Totime
and 'DTPicker6' between FromTime and Totime) and status=7)try
1、DTPicker5-DTPicker6的时间段完全包含在18-22里
2、DTPicker5-DTPicker6与18-22有交集就行
3、DTPicker5-DTPicker6与18-22没有交集的
Set SiteStatus=1
Where TableName In
(Select TableName From tableBook Where BookDate='2010-05-13' and
('19:00:00' between FromTime and Totime OR '20:00:00' between FromTime and Totime)
and status=7)
Update Tables
Set SiteStatus=1
Where TableName In
(Select TableName From tableBook Where BookDate='2010-05-13' and
('19:00:00' between FromTime and Totime AND '20:00:00' between FromTime and Totime)
and status=7)
91坛子是一个论坛浏览管理工具,支持在线浏览, 离线浏览, 帖子收藏, 搜索等功能.目前支持的论坛有天涯, 百度贴吧, 猫扑, Yahoo, csdn, 西祠胡同及国内第一的科研论坛"小木虫".
官方站点:
http://rj.91.com/tanzi/
看帖子就是方便,看过或预读的帖子,想什么时候看都可以,不怕原帖是否已被删除!