regarding reading timestamp from database and writing it

[chiranjeevi]

hi all,
i have a data base and i retrieved timestamp value from the database using a ODBC Stage and a output container.
in the ODBC stage i specified the column type as timestamp.

when i view the data in the ODBC stage then i can see the exact values from my database.

now i want to use this shared container output in one of my parallel jobs.
i dragged the container in to my parallel job .

i linked this container to a sequential file.in the sequential file and the shared container ,i declared the type as timestamp only.

the job compiles properly but wont run.

it gives me a fatal error

countrycontainerC3,0:
"Returned timestamp format not recognised for field - co_chg_timestamp. Unable to set to Null."

can any body explain whats going on here.

[Amos.Rosmarin]

Hi,

Try to add a Modify stage and explicitly convert the field to timestamp.

[chiranjeevi]

hi amos,
i tried using a modifier and its giving the same error.

actually i think there is some error with the container.
if my time stamp doesnt have microseconds ,then it works,...
i mean if my time stamp format is yyyy-mm-dd hh:nn:ss
it works but if my timestamp is having microseconds also it wont work,

can u help me ....
awaiting ur reply,
chiranjeevi