Skip to Content
avatar image
Former Member

I need to pull milliseconds from a SQL db and format it in UTC format

I need to pull milliseconds from a SQL db and format it in UTC format.

My CR is version 2016 sp2. My date time field has the .000 millisecond but the custom format options don't allow for this format?

Any help is appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 22 at 12:56 AM

    Hi, Deborah,

    Which SAP product is your database working for? I suggest you specify the detailed product to the tag, so we could know if the area has some special recommendation on this topic.

    If your question is just for a pure Microsoft SQL Server question about how to format milliseconds in UTC format, not related SAP product, you could refer to the Microsoft document about DATEADD.

    Best regards,

    Cherry.

    Add comment
    10|10000 characters needed characters exceeded