String to Timestamp Conversion Error

atulgoel · Post by **atulgoel** » Wed Jul 18, 2012 7:07 am

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.

ArndW · Post by **ArndW** » Wed Jul 18, 2012 7:18 am

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

atulgoel · Post by **atulgoel** » Wed Jul 18, 2012 7:44 am

Thanks. Its working fine.