Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why I am getting year as 0020 instead of 2020 for the

User_5VAALDec 10 2020

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

Comments
Post Details
Added on Dec 10 2020
1 comment
9,191 views