Help with DateTrans function YYYY-MM-DDTHH:MM:SS.sssZ
I am trying to map a datetime field supplied by a call from Sybase Unwired Platform.
It is sending the date as format 2011-11-15T15:10:13.944Z and I am trying to use the Datetrans function to convert to the 20111115 required by an IDOC date field.
I am using
as the input format but it fails with runtime error Illegal pattern character 'T'
Can anyone help ?
Use the standard function "DateTrans", and see mainly this Java help, you will know exactly all the possibilities:
be careful on lowercase and ippercase, because the mean is different !
[http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html] (really good, )
Example: (not yours)
yyyy.MM.dd G 'at' HH:mm:ss z --> 2001.07.04 AD at 12:08:56 PDT
so with a text 'at'...
I'm sure you will have yours. Enjoy play.