Skip to Content
avatar image
Former Member

Conversion of specific time format to Datetime variable

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 01 at 04:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded