DSXchange

Hi,

Please tell me how to convert below string to TimeStamp format.

2012/06/04 03:10:23 AM

I am reading the above value from sequential file as Varchar, and wanted to write into Oracle table as Timestamp.

Please tell me what format should I specify in StringToTimeStamp() Function.

Thanks In Advance.

StringToTimestamp(In.Col,"%yyyy/%mm/%dd %HH:%nn:%ss %aa")

Thanks. Its working fine.