--某个时间段一日内的案件办结
select * from MSGTIMERECORD t where to_char(t.slsj,'yyyy-mm-dd') between to_char(t.djsj - 1, 'yyyy-mm-dd') and to_char(t.djsj, 'yyyy-mm-dd') and to_char(t.createtime,'yyyymmdd') between '20191009' and '20191010';
sql 时间段查询
最新推荐文章于 2024-07-06 03:45:26 发布