Date format [message #70152] |
Mon, 22 April 2002 10:36 |
Kousalya
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Can anyone answer my question in SQL Loader !!!
I am converting data from Sybase to Oracle. I BCP'ed the data from Sybase using "|". Some of the sybase columns are datetime and stored like
"Mar 13 2002 12:02:51:000PM" . Can any one help me out how to convert this to Oracle in the Control file.
thanks in advance.
|
|
|
Re: Date format [message #70153 is a reply to message #70152] |
Mon, 22 April 2002 11:03 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
if you can use oracle migration workbench, it automatically takes care of the conversion. And there seems to be no problem with oracle in dealing your format. just make sure that the concerned date column in oracle is defined with the same dateformat.
|
|
|