Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problems with Oracle functions.
I am trying to convert a number 20070303 into a date format column I
have tried a combination like this but I don;t seem to be able to find
the right syntax.
insert into temp_pa
(PRIOR_AUTH_CODE_NUM, eff_date, term_date)
select PRIOR_AUTH_CODE_NUM,
to_date(to_char(EFFECTIVE_DATE,'99999999'),'YYYYMMDD'),
to_date(to_char(TERMINATION_DATE,'99999999'),'YYYYMMDD')
from PRIOR_AUTHORIZATIONS;
Help!! Received on Wed Mar 07 2007 - 15:28:08 CST
![]() |
![]() |