Timestamp 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
suja.somu
Participant
Posts: 79
Joined: Thu Feb 07, 2013 10:51 pm

Timestamp conversion error

Post by suja.somu »

Source is csv file with the data format as 3/30/2013 09:04:05, reading as varchar(26) . Target is sql server database with datetime datatype .

function used
StringToTimestamp(Lnk_MapTargetColumns.Date_Received,"mm/%dd/%yyyy %hh:%nn:%ss")

getting the below error:
APT_CombinedOperatorController,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "mm/%dd/%yyyy %hh:%nn:%ss" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid format [mm/%dd/%yyyy %hh:%nn:%ss] used for string_from_time type conversion.

What is the error in the above function used
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Post by BradMiller »

Your main problem is that you are missing the "%" in front of the mm.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

% you have to put in before mm as suggested. However i noticed that its one digit month without filler. You might wanna try %m/%d....
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply