How to convert date to ISO 8601 in SQL-Server? [duplicate]

Question

I have a column with date format 2006-09-08 14:39:41.000.
I want make a view using this column but I need the date to display in ISO 8601: yyyy-MM-ddThh:mm:ss.SSSZ.
How can I convert it?

Answer 1

Conversion code for ISO 8601 is 126, you can use something like this:

SELECT CONVERT(VARCHAR, DateColumn, 126) FROM Table