以XE数据库中的employees表为例 获得所有员工入职的具体时间的年月日
select first_name||' '||last_name as 姓名,
to_char(sysdate,'YYYY/MM/DD') 当前时间,
hire_date 入职时间,
(trunc(trunc(months_between(sysdate,hire_date))/12))||'年'||
(trunc(months_between(sysdate,hire_date)-trunc(trunc(months_between(sysdate,hire_date))/12)*12))||'月'||
trunc((sysdate-add_months(hire_date,months_between(sysdate,hire_date))))||'天'
as 工作年限
from employees;