SQL & PL/SQL

Hi All,

I have data in date format but while loading data from file some dates are loaded wrongly as 21-Apr-0023 rather than 21-Apr-2023. Now how to convert all the rows to correct format of 21-Apr-2023 using to_date function ?

Sample Table is given below:

create table xx_ramesh_temp (hire_date date);

insert into xx_ramesh_temp values (to_date('21-Apr-0023','dd-MON-YYYY'));
insert into xx_ramesh_temp values (to_date('21-Apr-2023','dd-MON-YYYY'));

select to_char(hire_date,'dd-Mon-YYYY'),hire_date from xx_ramesh_temp;

Output currently as below:

21-Apr-0023 21-APR-23
21-Apr-2023 21-APR-23

Thanks,

Ramesh S.