error in converting varchar into dd/mm/yyyy
890271Jan 19 2012 — edited Jan 20 2012Hi all,
i need to insert the "date_of_birth" in 'dd/mm/yyyy'.
but in master table "date_of_birth" column is in Varchar2(15),and values in the master tables are not in proper format.
i.e) some values are like *'21-jan-1988'*,
and some are like *'01/21/1988'* and *'21-01-1988'*.
i need to insert into a new table in dd/mm/yyyy format.
thanks in advance.