DSXchange

Hello:

I have source date colum (report_dt) coming in as CHAR in the following format: YYYYMMDD (20120606) and I would like to convert into Timestamp so that I can load it in Oracle table as Timestamp (2012-06-06 00:00:00)

Parallel version has a StringToDate(report_dt, "%yyyy%mm%dd") functionality that does not exist in Server version I am developing. I tried Iconv/Oconv (after searching here and trying it out) but got lost somewhere and does not work.

Please help.

Thank You!!

Figured it out. Closed.

Solution to convert char (YYYYMMDD) to Timestamp (YYYY-MM-DD HH24:MI:SS) in "Server" edition
In the transformer
OConv(IConv(Dr.REPORT_DT, 'D/YMD[4,2,2]'), 'D-YMD[4,2,2]') : ' 00:00:00'