cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

cherry_tian
Explorer
0 Kudos

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.