Running 8.5 on unix
Input Strings coming in as:
1/1/2007 10:05:00 PM
12/10/2007 1:00:00 AM
Running this: StringToTimestamp(DSLink2.timestamp,"%(m,s)/%(d,s)/%yyyy %(h,s):%nn:%ss") outputs the data as:
01/01/2007 10:05:00
12/10/2007 01:00:00
I'd like the first timestamp since PM to be
01/01/2007 22:05:00
SO, as manual instructs I run it as this:
StringToTimestamp(DSLink2.timestamp,"%(m,s)/%(d,s)/%yyyy %(h,s):%nn:%ss %aa")
Process aborts with the following:
Caught exception from runLocally(): APT_ParseError: Parsing parameters "%(m,s)/%(d,s)/%yyyy %(h,s):%nn:%ss %aa" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid format [%(m,s)/%(d,s)/%yyyy %(h,s):%nn:%ss %aa] used for string_from_time type conversion.
No matter how I try to swing the %aa as the manual shows it aborts and says it's an invalid format.
Thanks
StringtoTimestamp using AM/PM not working
Moderators: chulett, rschirm, roy