sql 时间段查询
--某个时间段一日内的案件办结
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') betwee...
原创
2019-11-08 14:48:07 ·
330 阅读 ·
0 评论
关注
分享
扫一扫