Skip to main content

Biztalk/MS SQL - Xml friendly datetime format

SQL Server, the ISO-8601 format:

SELECT CONVERT(VARCHAR(50), GETDATE(), 126)  

returns => 2018-03-23T10:38:22.997

Comments