select * from table where ( godate between '2016-3-23' and '2016-3-27') or (endate between '2016-3-23' and '2016-3-27')
求解
...全文
654打赏收藏
如何写 两个日期字段 是否包含在 日期范围之内?
表中有两个日期字段, godate 与 endate ,想查询到 这两个字段,只要任意一下满足条件的记录,以下语句查不出来 select * from table where ( godate between '2016-3-23' and '2016-3-27') or (endate between '2016-3-23' and '2016-3-27') 求解