返回日期格式的话
1
|
select
trunc(add_months(sysdate,-12),
'year'
)
from
dual
|
返回字符格式的话
1
|
select
to_char(trunc(add_months(sysdate,-12),
'year'
),
'yyyy-mm-dd'
)
from
dual
|
获取当前年的1月份
1
|
select
to_char(trunc(add_months(sysdate,-0),
'year'
),
'yyyy-mm-dd'
)
from
dual
|