Modify Stage

sekaran12 · Post by **sekaran12** » Thu Oct 29, 2009 6:17 am

Hi,

I am using modify stage for type conversion.My requirement is to convert string to timestamp.

Modify Stage:

MBROPRT_STS_DTS:timestamp[microseconds]=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss.6](MBROPRT_STS_DTS)

Input is 2009-08-25 08:18:59.765482 , after conversion the output is 2009-08-25 08:18:59.0. the microsec is skipping.

Pls help me how to get all values in output.

Thanks,
Raj

ArndW · Post by **ArndW** » Thu Oct 29, 2009 6:24 am

Do you have the microseconds enabled in your output column under the "extended" tag?

ArndW · Post by **ArndW** » Thu Oct 29, 2009 10:19 am

Even with RCP enabled, you need to explicitly declare your modify stage modified output column and need to enable the "microseconds" in the extended attribute.