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.
String to timestamp conversation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Wed Jul 25, 2012 5:29 am
- Location: Mumbai
As the error notes, your format is invalid. From the docs:
For a timestamp, the format is %yyyy-%mm-%dd %hh:%nn:%ss. If extended to include microseconds, the format is %yyyy-%mm-%dd %hh:%nn:%ss.x, where x gives the number of decimal places seconds is given to.
For a timestamp, the format is %yyyy-%mm-%dd %hh:%nn:%ss. If extended to include microseconds, the format is %yyyy-%mm-%dd %hh:%nn:%ss.x, where x gives the number of decimal places seconds is given to.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 14
- Joined: Wed Jul 25, 2012 5:29 am
- Location: Mumbai
-
- Participant
- Posts: 14
- Joined: Wed Jul 25, 2012 5:29 am
- Location: Mumbai