Skip to Content
0

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

Nov 03, 2017 at 07:27 PM

43

avatar image
Former Member

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.

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

1 Answer

Cherry Tian
May 22 at 12:56 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded