Skip to Content
0

Conversion of specific time format to Datetime variable

Jan 01 at 10:48 AM

79

avatar image
Former Member

Hello,

I am using SAP MII 15.1

I am receiving timestamp in following format in XML form as below -

20171206T070000.000

I would like to convert it into standard Datetime datatype like below-

2017-12-06T07:00:00.000

I am trying to find if standard expression editor functions in link editor can help, but could not find so far.

Kindly advise.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
christian libich Jan 01 at 04:24 PM
0

You should be able to do it with the dateformat() function:

dateformat("20171206T070000.000", "yyyyMMdd'T'HHmmss.SSS", "yyyy-MM-dd'T'HH:mm:ss.SSS")

Here is a link to the data and time formats in the MII help:

https://help.sap.com/viewer/d70c3ac3566b41dd896cd7cecc94e14a/15.1.6/en-US/4cc6a33de8d47181e10000000a15822d.html

Regards

Christian

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you ! It worked.. :-)

0