How to convert SQL Server datetime to UTC Json format?

Question

I have column which is datetime in SQL Server, how can I get its Json based datetime format: "yyyy-MM-dd'T'HH:mm:ss.SSSZZ"?

By the way, I am using SQL Server 2014

Answer 1

use:

SELECT FORMAT(GETUTCDATE(),'yyyy-MM-ddTHH:mm:ssZ')

Output: 2017-12-06T23:13:34Z

SELECT FORMAT(GETUTCDATE(),'yyyy-MM-ddTHH:mm:ss.fffZ')

Output: 2017-12-07T09:43:03.153Z