DSXchange

HI All,

I have a date field coming from source file which has values like:

2/28/2009 8:03 PM Mchen
2/28/2009 8:03 PM Philip Law

My target is a DB2 Database which is TimeStamp value.

I have searched the forum.
Tried IsValid, Left, Right, Field, StringToTimeStamp but unable to convert the value to a Timestamp.
Any help is really appreciated.

What exactly did you try? Post your StringToTimestamp attempt syntax and we'll go from there.

Note that "Philip Law" and "Mchen" are not part of any date system that I know of, so you would need to remove that part of the string prior to conversion.

Yup, and you typically need to standardize the dates so month/day are forced to two digits and also handle the conversion of AM/PM to military time. Typically.

If not military time ("zulu"), then at least 24-hour clock, ideally using ISO 8601 standards (YYYY-MM-DD HH:MM:SS). You only get one format mask, but days and months can have one or two digits in them. That's why you need to force them to two digits by adding leading zeroes. Try to construct a timestamp string, using substring and concatenation techniques, that matches your default timestamp format; that's the easiest approach.

Sorry, yes meant time on a 24-hour clock not strictly "zulu" or GMT time.