String to timestamp conversation
Posted: Wed Oct 17, 2012 6:11 am
Hi,
In transformer stage i use String to Timestamp function like this :
StringToTimestamp(lnk_CONV.TS4,"%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS")
the data is coming to transformer either with this format or with 'space'.
Data in TS4 is proper.We are handling the 'space' also.
Though this transformation job is aborted showing this fatal error :
[APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid format [%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS] used for string_from_time type conversion.]
Please advice.
In transformer stage i use String to Timestamp function like this :
StringToTimestamp(lnk_CONV.TS4,"%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS")
the data is coming to transformer either with this format or with 'space'.
Data in TS4 is proper.We are handling the 'space' also.
Though this transformation job is aborted showing this fatal error :
[APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid format [%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS] used for string_from_time type conversion.]
Please advice.