select case
when to_char(sysdate, 'mm-dd') >= '12-26' then
(to_char(sysdate, 'yyyy') + 1)
else
(to_char(sysdate, 'yyyy') + 0)
end
FROM DUAL
select case
when to_char(sysdate, 'mm-dd') >= '12-23' then
to_char(sysdate, 'yyyy') || '-12-23'
else
(to_char(sysdate, 'yyyy') - 1) || '-12-23'
end
FROM DUAL
得到的结果如下: