hql的时间比较

[binjoo]

from Goods g where g.goodsBeginTime < 2010-01-06 and g.goodsEndTime > 2010-01-06

hql，这样怎么查不出来？？？

[张祥龙]

to_date("2010-01-06","yyyy-mm-dd")

[老紫竹]

from Goods g where g.goodsBeginTime < '2010-01-06' and g.goodsEndTime > '2010-01-06'

2面的单引号还是需要的了。

[islandrabbit]

可以试试这个：

                        String DATE_FORMAT = "yyyy-MM-dd";
			SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
			
			Query q = session.createQuery("from Goods g where g.goodsBeginTime < :date1 and g.goodsEndTime > :date2")
			q.setDate("date1", sdf.parse("2010-01-06"));
                        q.setDate("date2", sdf.parse("2010-01-06"));