BETWEEN对这个要好得多。你还必须转义DateTime，因为它是保留字。

SELECT * 
FROM   AM_TIMETABLE 
WHERE  `DateTime` BETWEEN '2012-08-08 00:00:00' AND '2012-08-20 00:00:00'

字符串

这样做可能会更好：

select * from AM_TIMETABLE where `DateTime`<='2012-08-20 00:00:00' and `DateTime`>='2012-08-08 00:00:00'

字符串
DateTime也可能是一个保留字，对此不太确定。如果是这样的话，你需要在它们周围加上反引号（一个单独的` before和after）

日期时间字段必须在引号内：

SELECT * 
FROM AM_TIMETABLE 
WHERE `DateTime` <= '2012-08-08 00:00:00' AND 
      `DateTime` >= '2012-08-20 00:00:00';

字符串
或者，您可以尝试：

SELECT * 
FROM AM_TIMETABLE 
WHERE `DateTime` NOT BETWEEN '2012-08-08 00:00:00' AND '2012-08-20 00:00:00';

型

您需要在日期时间值上加上引号。

你得把日期用引号括起来

set @start_date='2012-08-08 00:00:00';
   set @end_date='2012-08-20 00:00:00';
   select * from AM_TIMETABLE where DateTime<=@start_date and DateTime>=@end_date

字符串

你可以像这样在between关键字中使用强制转换。我认为这是最好的办法

SELECT * FROM AS_TIMETABLE WHERE DateTime BETWEEN CAST('2012-08-08 00:00:00' AS DATETIME) AND CAST('2012-08-08 00:00:00' AS DATETIME);

字符串