select id,to_char(sysdate,'yyyy') year,to_char(sysdate,'mm') mm,to_char(sysdate,'dd') day from allactive where id=2016112400001
oracle中 分别查出年月日用于报表的时间显示
于 2022-03-22 09:44:53 首次发布
select id,to_char(sysdate,'yyyy') year,to_char(sysdate,'mm') mm,to_char(sysdate,'dd') day from allactive where id=2016112400001