Re: Problems with Oracle functions.

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

Morgan's Library at www.psoug.org
Click on DATE FUNCTIONS.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org