Hi,

I have successfully copied a table from foxpro db using the ODBC HS connection which I followed from the docs.

The sample command was:

create table EMP as select * from emp@foxpro_db;

I found some puzzling result on the date fields though
when I compared the 2 tables (oracle and foxpro).

foxpro db:

use emp
select bday from emp

bday
----
12/05/51
02/05/96
10/19/95
05/21/01
04/10/00

On Oracle DB:

select bday from emp;

bday
----
05-DEC-51
05-FEB-96
19-OCT-95
21-MAY-01
10-APR-00

which I presumed will be the same result as above (foxpro result). but
when i display it using to_char(bday,'mm-dd-yyyy ')

select to_char(bday,'mm-dd-yyyy ') from emp;

bday
----
02-05-9696
10-19-9995
12-05-2051
05-21-3001
04-10-2200

The month and day seemed ok but the year were not, i cant even see
a pattern how much did it added to it.

Any idea plsssss.....thanks