String to timestamp
Posted: Thu Jun 19, 2008 10:10 am
Hi,
Iam using the function
StringToTimestamp(DSLink2.XXXX,"yyyy-mm-dd hh:nn:ss")
DSLink2.XXXX='2005-01-01 12:01:01'(varchar(50))
When i tried to execute above, getting the following error.
Transformer_3,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "yyyy-mm-dd hh:nn:ss" 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] used for string_from_time type conversion.
I looked into forums but could not get exact error posts.
we are having datastage v 7.5.1
Thanks
Iam using the function
StringToTimestamp(DSLink2.XXXX,"yyyy-mm-dd hh:nn:ss")
DSLink2.XXXX='2005-01-01 12:01:01'(varchar(50))
When i tried to execute above, getting the following error.
Transformer_3,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "yyyy-mm-dd hh:nn:ss" 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] used for string_from_time type conversion.
I looked into forums but could not get exact error posts.
we are having datastage v 7.5.1
Thanks