HQL语句:mysql中怎么比较日期

HQL语句:mysql中怎么比较日期

String hql = "from MaintainInfo where begDate>=1992-11-24 and endDate <=2009-11-02";
这个语句应该怎么改才正确?

---

String hql = "from MaintainInfo where begDate>='1992-11-24' and endDate <='2009-11-02'";

---

引用

String hql = "from MaintainInfo where begDate>='1992-11-24' and endDate <='2009-11-02'";

正确

---

1楼正确
日期要用单引号括起来

---

引用

String hql = "from MaintainInfo where begDate>='1992-11-24' and endDate <='2009-11-02'";

正解！

---

引用

String hql = "from MaintainInfo where begDate>='1992-11-24' and endDate <='2009-11-02'";

确实正确

---

String hql = "from MaintainInfo where begDate>='1992-11-24' and endDate <='2009-11-02'";

---

可以结贴了..