select ceil( TO_DATE('${enddate}','yyyymmdd') - TO_DATE('${startdate}','yyyymmdd') ) days, -1 daycount from dual
oracle ceil
最新推荐文章于 2023-12-01 17:13:40 发布
select ceil( TO_DATE('${enddate}','yyyymmdd') - TO_DATE('${startdate}','yyyymmdd') ) days, -1 daycount from dual