Time Conversion

Xpert · Post by **Xpert** » Tue Feb 24, 2009 11:45 pm

Hi,

From sequential file, i'm getting time value as 00:00:00 and need to load to oracle database. But I'm not able to load the value, its giving the below error message.

J_Time_Convert..Tran_Detail_Records: At row 1, link "Lnk_2", while processing column "MAKERTIME"
Value treated as NULL
Attempt to convert String value "00:00:00" to Time type unsuccessful

I have used the Iconv and oconv function as below in transformer.

Oconv(Iconv(Src_Transfer.MAKERTIME,'MTS'),'MTS')

Please help me out in this.

chulett · Post by **chulett** » Tue Feb 24, 2009 11:48 pm

You need to load this into what datatype in Oracle? There's no "time" type, so what... DATE? TIMESTAMP? VARCHAR2? Only the latter will take a "time" value with no correspoding date associated with it.

Xpert · Post by **Xpert** » Wed Feb 25, 2009 12:06 am

chulett wrote:You need to load this into what datatype in Oracle? There's no "time" type, so what... DATE? TIMESTAMP? VARCHAR2? Only the latter will take a "time" value with no correspoding date associated with it.

Chulett,

I changed the column to varchar in oracle table and now it is working.

Thanks for your reply.

chulett · Post by **chulett** » Wed Feb 25, 2009 8:24 am

Then... Resolved?