执行下面的HQL语句,发现3月31日的记录无法查询到,百思不得其解。
后来发现数据库是以03月31日00:00:00为截止点,所以需要修改为:
引用内容
select count(a.click) from Article as a where (a.sendTime between '2009-03-01' and '2009-03-31') and a.admin=56 and (a.state=1)
后来发现数据库是以03月31日00:00:00为截止点,所以需要修改为:
引用内容
select count(a.click) from Article as a where (a.sendTime between '2009-03-01' and '2009-03-31 23:59:59') and a.admin=56 and (a.state=1)