select ceil( TO_DATE('${enddate}','yyyymmdd') - TO_DATE('${startdate}','yyyymmdd') ) days, -1 daycount from dual
oracle ceil
最新推荐文章于 2024-04-20 00:19:20 发布
select ceil( TO_DATE('${enddate}','yyyymmdd') - TO_DATE('${startdate}','yyyymmdd') ) days, -1 daycount from dual