dear all,
we all know that date - date = number
so i send this code to convert it to year-monthes-days
i wish it be usfull for u all this is my first time to send here and thanks for all the great thing i learn it from here
wish u all the best
=====================================================================
select floor((sysdate-work_date)/365) years,
floor(floor((((sysdate-work_date)/365) - floor(((sysdate-work_date)/365)))*365)/30) monthes,
(floor((((sysdate-work_date)/365) - floor(((sysdate-work_date)/365)))*365)/30 -
floor(floor((((sysdate-work_date)/365) - floor(((sysdate-work_date)/365)))*365)/30))*30 dayes
from emp
=====================================================================

Thank u .. it's very usfull idea ..
annnnnnd <Welcome Here >

يسلمو كتير hanywaseem

و 999999999999999 welcome