DSXchange

Hello I am posting the derivations , I want to convert the out_data.Duration from decimal to timestamp. I am doing first conversion in stage variable svr (stage variable)----> DecimalToString(out_data.Duration) second conversion(string to timestamp) derivation is StringToTimestamp(svr,'%yyyy-%mm-%dd...

Hello
I did the isolation of the conversion also.
when converting from decimal to string the sample output is

000000085363200.00000
000000000086400.00000
000000000172800.00000
but when i am converting from string to timestamp its giving '*********'

Hi All, In my project we use DB2 as source,I am loading data into a dataset which is having field with decimal type.I am converting this to timestamp using 2 step conversion first convertnig decimal to string and again converting that string to timestamp.when i am converting string to timestamp its ...