Changing a date format
653816Nov 11 2008 — edited Nov 12 2008Hi,
I am trying to change all values in my IMP_DATE Column so that they show a date format similar to this : May 12 2003
At the moment all dates are shown in this format: 12-MAY-2003
If i try the following sql i get an error saying ORA-01858 a non-numeric character was found where numeric was expected
The format of the IMP_DATE is date
UPDATE MONICA_TAB2
SET IMP_DATE = to_char(IMP_DATE,'FMMonth DD YYYY')
where IMP_DATE is not null;
Any help will be appreciated
Thanks