select to_date(trunc(sysdate)) - to_date(trunc(create_time)) from table_201410;
转载于:https://www.cnblogs.com/yangpeng-jingjing/p/6806206.html
select to_date(trunc(sysdate)) - to_date(trunc(create_time)) from table_201410;
转载于:https://www.cnblogs.com/yangpeng-jingjing/p/6806206.html