Skip to Content
0
Former Member
Nov 09, 2007 at 02:02 PM

Parsing UTC Date/Time Values

228 Views

What java class/method does the TransformDate function use?

I'm trying to parse the following UTC formated date string with the TransformDate function.

<b><DateTime DateTimeQualifier="On">2007-11-02T20:17:28Z</DateTime></b>

According to the API Docs for Java" target="_blank">http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html">Java Simple Date Format says that the input mask should look like this:

yyyy-MM-ddTHH:mm:ssZ

Integration builder chokes on the "T" literal character. Wrapping the T in single (or double) quotes doesn't get it done either.

How have you solved transformed date strings like this?