I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type.
If I run a convert on the table, my date comes out in the right format.
(Eg: 2006-04-03 00:00:00). This is fine.
However when I run this date as an sql query in a programme in C#, and save to xml the result is 2006-04-03 00:00:00+02:00.
I need to get rid of the +02:00 part. If I check my windows date time settings, it is set to GMT+2:00. This could be the reason but changing my date time settings still returns the same value i.e:2006-04-03 00:00:00+02:00.
I need to get rid of the +02:00 part.