timestamp to string conversion error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

timestamp to string conversion error

Post by deesh »

Hi While i am trying to convert the string to timestamp getting below error.

Caould some one help to me.

Numeric value first converting into string and then that string value converting to timestamp.

using format in the transformer ::stringToTimestamp(var1,"%yyyy-%mm-%dd %hh:%nn:%ss")

Error: APT_CombinedOperatorController,1: Data string '20161114051100.' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %nn.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Error says it all. The format mask you use needs to match the incoming data, not what you think the end result should be. This so it knows how to parse it. It already knows what the end result needs to be.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply