select trunc(sysdate- to_date(to_char(j.create_date,'yyyy-mm-dd'),'yyyy-mm-dd')) 相差天数 from sys_user j where j.id='100008881'
转载于:https://www.cnblogs.com/yy123/p/5703427.html
select trunc(sysdate- to_date(to_char(j.create_date,'yyyy-mm-dd'),'yyyy-mm-dd')) 相差天数 from sys_user j where j.id='100008881'
转载于:https://www.cnblogs.com/yy123/p/5703427.html