Re: Parsing ORACLE format dates

In article <1993Jun2.160933.15334_at_news.unomaha.edu> moswald_at_cwis.unomaha.edu (Mike Oswald) writes:

> If you have defined your table fields as DATE and at the FoRM level Oracle
> should already do this checking for you. That is if your defaulting to
> the system date format (DD-MON-YY).

The thing is I'm not using Forms - what I have is a C program which does preprocessing on some data before passing it to SQL*Loader. The data can contain dates in any format (although the format is known). When SQL*Loader sees the data it obviously complains at any invalid dates, but I was hoping to be able to do it at an earlier stage, preferably without using PRO*C, which will slow the preprocessing down. Hence the need for an ORACLE date-format parser.

I hope this makes more sense.

Andy

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Andy Caiger                                     Rothamsted Experimental Station
                                                  Harpenden, Herts. AL5 2JQ. UK
e-mail: caiger_at_resa.afrc.ac.uk                          +44 (0)582 763133 x2418
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-