LogoutDateTime>endTime and LogoutDateTime<beginTime 试一下
LogoutDateTime他是数据库中日期型的字段 另外2个是字符串 这不可能比较
beginTime 和 endTime 不都是字段名吗?那就不应该要引号了。试试下面的:LogoutDateTime BETWEEN CONVERT(DATETIME,beginTime) AND CONVER(DATETIME,endTime)LogoutDateTime BETWEEN cast(beginTime as datetime) AND cast(endTime as datetime)
and LogoutDateTime<beginTime
试一下
另外2个是字符串
这不可能比较