返回日期格式的话
select trunc(add_months(sysdate,-12),'year') from dual
返回字符格式的话
select to_char(trunc(add_months(sysdate,-12),'year'),'yyyy-mm-dd') from dual
返回日期格式的话
select trunc(add_months(sysdate,-12),'year') from dual
返回字符格式的话
select to_char(trunc(add_months(sysdate,-12),'year'),'yyyy-mm-dd') from dual
