Converting Varchar to Timestamp

jweir · Post by **jweir** » Mon Nov 08, 2010 9:28 am

Hello,

I am trying to convert a field that is varchar (8) to a timestamp (26,6).

I have tried the StringtoTimestamp function, which did not work. I have also tried PadString, but it was unsuccessful.

Does anyone have any suggestions?

Thanks in advance.

vinothkumar · Post by **vinothkumar** » Mon Nov 08, 2010 9:40 am

Can you post your derivation having StringToTimestamp. Also give the sample value for that column

jweir · Post by **jweir** » Mon Nov 08, 2010 10:00 am

Sample value: 20100808

Derivation: StringToTimestamp((lnk_GL_BALANCES_MED.POSTING_DATE:'000000'),"%yyyy%mm%dd%hh%nn%ss")

This was the solution we found. We had to pad the hours, minutes, and seconds.