-
HS date conversion error
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|