Formatting datetime values returned in a SELECT..FOR XML statement
- by TelJanini
Consider the following table:
Orders
OrderId Date CustomerId
1000 2012-06-05 20:03:12.000 51
1001 2012-06-16 12:02:31.170 48
1002 2012-06-18 19:45:16.000 33
When I extract the Order data using FOR XML:
SELECT
OrderId AS 'Order/@Order-Id',
Date AS…