and怎么报错了 SELECT *
FROM MealRecords
WHERE (sign_time NOT BETWEEN (('2011-03-01 07:15' AND '2011-03-01 08:25') AND
('2011-03-01 11:30' AND '2011-03-01 12:50') AND ('2011-03-01 17:15' AND
'2011-03-01 19:10') AND ('2011-03-01 23:25' AND '2011-03-01 24:30') AND
('2011-03-01 03:40' AND '2011-03-01 04:20'))
select *
from 表名
where DatePart(hh,时间列) not between 7 and 8
and DatePart(hh,时间列) not between 7 and 8
你那样写条件是错误的。应该为:
SELECT *
FROM MealRecords
WHERE (sign_time NOT BETWEEN '2011-03-01 07:15' AND '2011-03-01 08:25'
AND
sign_time NOT BETWEEN '2011-03-01 11:30' AND '2011-03-01 12:50'
AND
sign_time NOT BETWEEN '2011-03-01 17:15' AND '2011-03-01 19:10'
AND
sign_time NOT BETWEEN '2011-03-01 23:25' AND '2011-03-01 24:30'
AND
sign_time NOT BETWEEN '2011-03-01 03:40' AND '2011-03-01 04:20'