mySQL datetime比较语法错误

Question

我正在为我的母亲制作一个预订系统，我在锁定已经预订的时间时遇到了一些问题。

代码如下:

SELECT event_start
FROM annagretasjoberg
WHEREevent_start BETWEEN 2011-8-1 1:30:00 AND 2011-8-1 2:0:00

这是来自 mySQL 服务器的回复:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1:30:00 and 2011-8-1 2:0:00' at line 1

Answer 1

日期数据类型必须用引号引起来:

select event_start from annagretasjoberg where event_start 
between '2011-8-1 1:30:00' and '2011-8-1 2:0:00'