Date Format for year 1900 and 2000
544866Sep 7 2007 — edited Sep 7 2007Hi friends,
I have to convert a date as '07-feb-47' in to date fromat and then convert it into char format into dd-mm-yyyy format.
but when I am going to convert this it will showing the year as 2047 in place of 1947.
Please guide me.
as
select to_char(to_date('07-feb-47'),'dd-mm-yyyy') from dual
gives the result as:
07-02-2047
in place of required data is
07-02-1947
Regards,
Ritesh Sharma