%hh is a 24 hour format, you'd need to use %H or %HH for 12 hour, depending on if the length of that portion is variable (1...12) or fixed (01...12) in size.
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:%hh is a 24 hour format, you'd need to use %H or %HH for 12 hour, depending on if the length of that portion is variable (1...12) or fixed (01...12) in size. ...
chulett wrote:What solution did you use - all that extra work using stage variables or the proper StringToTimestamp function syntax that Kryt0n helped out with? ...
One which Neena provided, as i dont wanna store am/pm in table and also wanna store it in 24 hrs format..
She provided a perfect solution.
got aborted with following error
APT_CombinedOperatorController,0: Unrecognized timestamp format identifier: %97
APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%yyyy%mm%dd %hh.%nn.%ss %aa" 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 %aa] used for string_from_time type conversion.
Operator signalled one or more errors.
Looking at your "actual" input data ... is there a space between the day and hour? (your format looks like you have a space there)