Attempt to convert String value

[adams06]

how to convert a String value "02-JUN-04" to Timestamp

[DSguru2B]

From first glance "26-APR-06" doesnt look like a timestamp to me. You need to use iconv/oconv functions to convert it to timestamp.

[ray.wurlod]

Code: Select all

Oconv(Iconv("26-APR-06", "DDMY"), "D-YMD[4,2,2]") : " 00:00:00"

[adams06]

Hi Ray,

Input is coming in this format 04/26/2006 14:19:11

but i am getting error as

TABLE1..Transformer_1: At row 200, link "TO", while processing column "U_LOAD_TS"
Attempt to convert String value "26-APR-06" to Timestamp type unsuccessful

how to resolve this.

Thanks in advance.

Code: Select all

Oconv(Iconv("26-APR-06", "DDMY"), "D-YMD[4,2,2]") : " 00:00:00"

...

[kcbland]

What is the target stage you are using? It matters.

[pkomalla]

You can use the following derviation in the transformer

TIMESTAMP(Iconv(date column,"D DMY[,A3,2]"))

It works....

TIMESTAMP is in DS Transforms/built-in/date

[adams06]

TIMESTAMP(Iconv(date column,"D DMY[,A3,2]"))
its returning a NULL value

You can use the following derviation in the transformer

TIMESTAMP(Iconv(date column,"D DMY[,A3,2]"))

It works....

TIMESTAMP is in DS Transforms/built-in/date

[jreddy]

DateTimeStampToOraOCIWithTime(DateGenericToTimeStamp(link.inputcolumnname))


this should work with a generic input timestamp.. and when the target is a oraOCI stage

[ray.wurlod]

You changed the question. Originally you asked about DD-MMM-YY, and my answer handled that. Now you specify that there's a time component too, which necessarily changes the rules. Iconv() won't work with the date and time in one string. Try

Code: Select all

Oconv(Iconv(Field(InLink.TheCol, " ", 1, 1), "DDMY"), "D-YMD[4,2,2]") : InLink.TheCol[Col2(), 7]