现阶段系统时间在给定日期之间hql查询语句

分类: IT文章 • 2022-08-18 14:52:05

当前系统时间在给定日期之间hql查询语句

FROM Entity sa WHERE sa.state=1 and sysDate() BETWEEN sa.beginDate AND sa.endDate order by sa.id asc