Timestamp value in Stage Variable

[vikas99143]

I need to validate timestamp field using stage variables. I am reading the field as Varchar from Input file(comma delimited file).When I am doing string to timestamp conversion and storing it in staging variable having SQL Type as Timestamp and Extended to microseconds, the microsecond value are not coming in stage variable. Please advise how to handle this.

[ray.wurlod]

Welcome aboard.

You often get a quicker answer using Search - as it happens this very question is the topic of a current thread. Please track it down. If you then have further questions, you can add them right here.