DATE FORMAT

karry450 · Post by **karry450** » Fri Oct 30, 2009 3:57 am

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

ArndW · Post by **ArndW** » Fri Oct 30, 2009 4:32 am

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.

gssr · Post by **gssr** » Fri Oct 30, 2009 5:37 am

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?

chulett · Post by **chulett** » Fri Oct 30, 2009 7:13 am

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'.

anil.kr06 · Post by **anil.kr06** » Fri Oct 30, 2009 11:48 am

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

chulett · Post by **chulett** » Fri Oct 30, 2009 11:59 am

Please do not hijack other people's threads.

Start your own topic and we'd be happy to help you.

anil.kr06 · Post by **anil.kr06** » Fri Oct 30, 2009 12:16 pm

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

chulett · Post by **chulett** » Fri Oct 30, 2009 12:28 pm

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.

DSXchange

DATE FORMAT

DATE FORMAT

Conversion of date farmat