17,086
社区成员
发帖
与我相关
我的任务
分享
select ename,
trunc(months_between(sysdate,hiredate)/12) y,
mod(trunc(months_between(sysdate,hiredate)),12) m,
mod(to_char(sysdate,'DD')-to_char(hiredate,'DD')+to_char(trunc(sysdate,'MM')-1,'DD'),to_char(trunc(sysdate,'MM')-1,'DD'))d
from emp
trunc(sysdate,'MM')-to_date(to_char(sysdate,'YYYY')||to_char(sysdate,'MM')-1,'YYYYMM')
select ename,
trunc(months_between(sysdate,hiredate)/12) 年,
mod(trunc(months_between(sysdate,hiredate)),12) 月,
mod(to_char(sysdate,'DD')-to_char(hiredate,'DD')+30,30) 日
from emp
select ename from emp where
substr(ename,0,1)=upper(substr(ename,0,1))
and substr(ename,2)=lower(substr(ename,2))