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'";

---

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'";

是的哦,谢谢啦!