My source is a flat file. I have a timestamp column coming as Varchar. THe data is in the format 2011-02-02T14:05:35.
I need to load it to Timestamp Column.
I am using the below transformation in Transformer.
Code: Select all
StringToTimestamp(Link1.Col1,"%YYYY-%MM-%DDT%hh:%mm:%ss")
Code: Select all
APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%yyyy-%mm-%ddT%hh:%mm:%ss" for conversion "timestamp=timestamp_from_ustring[%yyyy-%mm-%dd %hh:%nn:%ss](ustring)": APT_Conversion_String_TimeStamp: Invalid format [%yyyy-%mm-%ddT%hh:%mm:%ss] used for string_from_time type conversion.
Cheers!!!!