Hi There,
I am trying to load a date column with the following format
2009-03-02 09:14:11.138000 from oracle to oracle but my target instance is ora bulk loader which is having only
time format as hh24:mi:ss
and hh:mi:ss am can
but my data fails to insert into target with this formats can anyone help me with this issue
Im getting this error
ORA-26041: DATETIME/INTERVAL datatype conversion error
DATE FORMAT
Moderators: chulett, rschirm, roy
In DataStage, what data type is this column? I ask because date data types have no format, but string types do. A string would then need to be converted to the data type that Oracle is expecting.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Conversion of date farmat
chulett wrote:That's not an Oracle DATE, but rather a TIMESTAMP. While the former can hold a time, only the latter can hold milliseconds. That is the root of your 'conversion error'. ...
Hello ,
I have date format in source is dd-mm-yyyy and want to
load in target table as yyyy-dd-mm. Could any body please help on this?
Anil
Hi,chulett wrote: Please do not hijack other people's threads.
Start your own topic and we'd be happy to help you.
Appreciate yours suggestion. I have started posting my question just few days back.
Initially, really tired of while finding out the way where I can start my own thread. Could you please help me on this?
Regards,
Anil
If you're saying you don't know how to start a new topic, from the Forum view (i.e. 'inside' sny forum where all the topics are listed) there is a Post New Topic button at the top and the bottom of the screen. There's also one inside each topic as well, like right here and right now for instance. Pick either one. There's also a Reply To Topic button that let's you reply without all that extra quoting clutter.
Make sure you are in the appropriate forum, the job type can significantly change the answers you'll get.
Make sure you are in the appropriate forum, the job type can significantly change the answers you'll get.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers