Skip to Main Content

SQL & PL/SQL

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!

when i pass year as 50 then output coming as 1950 it taking past Century instead of new. plz help?

User_J93KYFeb 8 2022

select to_date('50', 'rrrr') from dual;
OUTPUT: 2/1/1950

Comments
Post Details
Added on Feb 8 2022
3 comments
641 views