Re: Problems with Oracle functions.

On 7 Mar 2007 13:28:08 -0800, "Ora" <ed.rohwer_at_gmail.com> wrote:

>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!!

You mean someone here should run this code in his own database in order to reproduce the as of yet unknown error, you don't want to disclose here?
If so, please submit a SR with OTS, at least they are getting paid for doing your work.

-- 
Sybrand Bakker
Senior Oracle DBA