select to_char(count(*)) as jrchzs from SJ_CLUE_INFO t where t.bssj>=to_date(to_char(SYSDATE,'yyyy-MM-dd'),'yyyy-MM-dd') and t.bssj<=to_date(to_char(SYSDATE,'yyyy-MM-dd'),'yyyy-MM-dd')+0.99999 and t.b_zt='2' and t.shdw_dm =?
后面的+0.99999是59.59,
oracle获取当天数据
最新推荐文章于 2024-07-24 17:02:05 发布