Converting date time in C#

5 pts.
Tags:
C
Data Types
DateTime
SQL
VARCHAR
XML
hi all, 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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following