Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL load problem
I found the answer at
http://technet.oracle.com/doc/server.815/a67792/ch05.htm#20510 ...
LOAD DATA
INTO TABLE DATES (COL_A POSITION (1:15) DATE "DD-Mon-YYYY")
BEGINDATA
1-Jan-1991
1-Apr-1991 28-Feb-1991
Kurt
sc wrote:
> I was trying to load data to a table, but the oraiginal data for the DATE
> column is like this:
> "1988269000000", and I always got error message that the format is not
> right, could someone tell me how to load this kind of data into the table?
>
> Thanks
Received on Sun Oct 01 2000 - 09:23:13 CDT
![]() |
![]() |