Re: Urgent negative date loading into table field.

On Mon, 27 Apr 1998 15:07:29 +0530, T Suresh kumar <sureshkt_at_hotmail.com> wrote:
>
>Hai
> Can any one tell me a way to load negative dates into Oracle table
>through SQL*Loader ?
> I need to load the date 01/ 01 / -9999 00:00:00 in to Oracle table
>field.
> I tried in control file by giving format as "DD/MM/YYYY BC
>HH24:MI:SS" but it went in vain.
>

This date is outside the range supported by Oracle. Valid dates have to be between Januari 1th 4712 BC and December 31th 4712 AD inclusive. So there is no hope to load the given date correctly. For signed years Oracle does have the SYYYY format option, so if the date had been "01/01/-4000 00:00:00" you could have loaded it with "DD/MM/SYYYY HH24:MI:SS". Greetings

Henk de Wilde Received on Mon Apr 27 1998 - 16:29:31 CDT