在where语句中,如何判断两端时间是否有交集?
具体情形:已知时间段:firsttime 和secondtime
表中有字段begintime和endtime
凡是和firsttime和begintime有交集记录都需要我写的是:where firsttime between begintime and endtime
or secondtime between begintime and endtime
or begintime between firsttime and secondtime
or endtime between firsttime and secondtime觉得不是这样子的谢谢
具体情形:已知时间段:firsttime 和secondtime
表中有字段begintime和endtime
凡是和firsttime和begintime有交集记录都需要我写的是:where firsttime between begintime and endtime
or secondtime between begintime and endtime
or begintime between firsttime and secondtime
or endtime between firsttime and secondtime觉得不是这样子的谢谢
解决方案 »
- !!!postgres月份计算!!!
- 如何判断某条记录的某字段为NULL,即未赋值
- Mysql 3个表之间的操作,求sql语句
- mysql的declare只能用在存储过程中么?
- postgresql 远程连接的命令?
- 求助!Innodb中外键是否必要?
- 请问怎样向远程的MYSQL服务器上传递一个数据库呢
- mysql启动时的1067错误如何解决啊?
- 我起先用solaris自带的apache安装了web,我现在想加入php+mysql支持,我该怎么做?
- 【MYSQL】ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- 为何下面代码执行出错。谢谢!
- 求批量更新MySQL语句
表中有字段begintime和endtimeselect * from table1 where tdatetime between
if(firsttime<begintime,firsttime,begintime) and if(secondtime>endtime,secondtime,endtime)
if(firsttime>begintime,firsttime,begintime) and if(secondtime<endtime,secondtime,endtime)上面的写反了,这个才对。。
from 表
where begintime>=@firsttime and endtime<=@secondtime
tdatetime 这个是什么东西?
from 表
where begintime<=@secondtime and endtime>=@firsttime