String varchar yyyymmdd to Oracle date error
Posted: Mon Aug 06, 2007 8:27 am
Hi,
I am reading from a file with one column DT1 (varchar) having date values '20070802'. I am trying to load this in an Oracle table column AS_OF_DATE( timestamp), after using the following conversion code OCONV(ICONV(DT1, "DYMD[4,Z,Z]"),"D-YMD[4,2,2]") : " 00:00:00".
It does't throw any error but the jobs aborts. It lists a log message as
"insTdwFxRateCurrency..TRN_TypeConversion: The value of the row is: AS_OF_DATE = 2007-08-06 00:00:00 SOURCE_SYSTEM_ID = IBS SITE = BOS BRANCH = 01 CURR_CODE = ABC CURR_DESC = TEST CURRENCY SPOT_RATE_IND = M SPOT_RATE = 1 MARKET_NOSTRO_POS = 0"
I have checked all other target cols, they seem to be Ok.
what is going wrong here.
I am reading from a file with one column DT1 (varchar) having date values '20070802'. I am trying to load this in an Oracle table column AS_OF_DATE( timestamp), after using the following conversion code OCONV(ICONV(DT1, "DYMD[4,Z,Z]"),"D-YMD[4,2,2]") : " 00:00:00".
It does't throw any error but the jobs aborts. It lists a log message as
"insTdwFxRateCurrency..TRN_TypeConversion: The value of the row is: AS_OF_DATE = 2007-08-06 00:00:00 SOURCE_SYSTEM_ID = IBS SITE = BOS BRANCH = 01 CURR_CODE = ABC CURR_DESC = TEST CURRENCY SPOT_RATE_IND = M SPOT_RATE = 1 MARKET_NOSTRO_POS = 0"
I have checked all other target cols, they seem to be Ok.
what is going wrong here.