Why I am getting 0020 instead of 2020 for below query.
select to_char(to_date(sysdate,'dd-mm-yyyy'),'iyyy') from dual.
Instead of sysdate if I give date like '5-dec-2020' it's giving correct.
Any ideas why iso value for sysdate year is coming as 0020