string to timestamp
Posted: Wed May 12, 2010 12:50 am
hi,
my input column:doc_guid
datatype :varchar
I want to insert this value into target
StringToTimestamp(lk_read.sheet,"yyyy-mm-dd hh:nn:ss")
i want to implement this in transformer.
I am getting below error
APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "yyyy-%mm-%dd hh:nn:ss" for conversion "timestamp=timestamp_from_ustring[%yyyy-%mm-%dd %hh:%nn:%ss](ustring)": APT_Conversion_String_TimeStamp: Invalid format [yyyy-%mm-%dd hh:nn:ss] used for string_from_time type conversion.
So can anyone please help me on this
Thanks in advace
my input column:doc_guid
datatype :varchar
I want to insert this value into target
StringToTimestamp(lk_read.sheet,"yyyy-mm-dd hh:nn:ss")
i want to implement this in transformer.
I am getting below error
APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "yyyy-%mm-%dd hh:nn:ss" for conversion "timestamp=timestamp_from_ustring[%yyyy-%mm-%dd %hh:%nn:%ss](ustring)": APT_Conversion_String_TimeStamp: Invalid format [yyyy-%mm-%dd hh:nn:ss] used for string_from_time type conversion.
So can anyone please help me on this
Thanks in advace