I have date with year thats 19 but is actually coming out as 0019 instead of 2009. ORDER\_DATE is a date field.

So when I do 

```
select ORDER_DATE, TO_CHAR(ORDER_DATE,'YYYY/MM/DD') from table abc

```

I get:

```
30-JUN-19   0019/06/30
30-APR-19   0019/04/30
31-DEC-21   2021/12/31
23-JAN-19   2019/01/23

```

Is there way to change 0019 year to 2019?

I tried:

```
SELECT case when extract(year from ORDER_DATE) = 19 
    then add_months (ORDER_DATE,24000) 
    else ORDER_DATE 
end as fixed_date 
from abc

```

But not sure if thats the best way. 

thanks