Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problems with Oracle functions.

Problems with Oracle functions.

From: Ora <ed.rohwer_at_gmail.com>
Date: 7 Mar 2007 13:28:08 -0800
Message-ID: <1173302888.710379.132180@v33g2000cwv.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US