Page 1 of 1
DATE FORMAT
Posted: Fri Oct 30, 2009 3:57 am
by karry450
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
Posted: Fri Oct 30, 2009 4:32 am
by ArndW
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.
Posted: Fri Oct 30, 2009 5:37 am
by gssr
You are getting the records from Oracle ,Then whts the datatype in it?
Can you able fetch the records from the Oracle as the datatype may be relevant?
Posted: Fri Oct 30, 2009 7:13 am
by chulett
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'.
Conversion of date farmat
Posted: Fri Oct 30, 2009 11:48 am
by anil.kr06
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
Posted: Fri Oct 30, 2009 11:59 am
by chulett
Please do not hijack other people's threads.
Start your own topic and we'd be happy to help you.
Posted: Fri Oct 30, 2009 12:16 pm
by anil.kr06
chulett wrote: Please do not hijack other people's threads.
Start your own topic and we'd be happy to help you.
Hi,
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
Posted: Fri Oct 30, 2009 12:28 pm
by chulett
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.