I have a requirement where I need to format the date in
“YYYYMMDDHHMMSS” format and generate XML file. Since there is a space in the table in betweenDay and Hours so that a letter T appears in the actual XML file when the XML is getting generated as :
Value in the table as :
2010-09-07X 00:00:00.000 - A blank space is there in the
X place ..
Value of the XML O/p as
<AccountingValueDate>2010-09-03T13:31:20.803</AccountingValueDate> --Where we can see a
T appears which I want to remove
The query is below:
FROM Product.Account AD
I have tried something like below but it is not working:
FROM Product.Account AD but it's not giving me the desired O/P
My actual requirement is I just want to remove the T from my XML output and format the date as
Please somebody suggest me how to do this asap... I am using SQL Server 2008 version.
Thanks a lot
View Complete Post