Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

yyyy-dd-MMTHH:mm:ss.SSS

as the input format but it fails with runtime error Illegal pattern character 'T'

Can anyone help ?

Former Member
Former Member replied

hi,

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, )

[http://java.sun.com/j2se/1.5.0/docs/api/java/util/Date.html]

[http://java.sun.com/j2se/1.5.0/docs/api/java/text/DateFormat.html]

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.

regards.

Mickael

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question