HS date conversion error
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).
select bday from emp
On Oracle DB:
select bday from emp;
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;
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
Click Here to Expand Forum to Full Width