Re: Char to Date but column has many different date formats.

In article <8bfhbf$als$1_at_nnrp1.deja.com>, tim.mcconechy_at_runtime.dk writes
>Hi!
>I need to import a character column to a date column
>but the dates or in many different formats:
>Quite difficult because there are many different types of date formats:
>
>I don't think it can be done but maybe some one has a way..

Looks like you need some PL/SQL code that for each row looks at the date-string and tries to create a valid date - working its way through a list of likely formats. Surround each attempt to create a date with an EXCEPTION block.

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================