Char to Date but column has many different date formats.

From: <tim.mcconechy_at_runtime.dk>
Date: 2000/03/24
Message-ID: <8bfhdo$am4$1@nnrp1.deja.com>#1/1

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

Example:

01 Aug
01 Sep
03 July

1-Aug-2000
1-Jul-2000
1-Oct-2000
1-Sep-2000
1-Sept-2000
1/2-00

1/3-00
1/3-00 w9
10-Sep-2001
10/4-00
12-Nov-2000
12/6-00
14-Aug-2000
15 Aug
15 August 2000
15 Sep

I know the code should look something like: For 15 Sep
update styles
set mod003=to_date(moc029,'dd MON');

For
15 August 2000
set mod003=to_date(moc029,'dd month yyyy');

But the problem is all will give the message

                   *

ERROR at line 2:
ORA-01843: not a valid month

Because this expects that all columns have the same date format.

Is there some way I can only get the dates with the format without the error message and maybe create 1 update statement for each column...

Thanks!!!!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 24 2000 - 00:00:00 CST