SQL datetime to C# string and back to SQL datetime

Question

I have a webservice method that gets data from sql of the format 2012-11-18 11:21:03 when i save it to C# string it becomes this format: 18.11.2012 11:21:03 How do i change it back to the SQL format 2012-11-18 11:21:03 ?

Answer 1

Parse it into a dateTime again

DateTime myTime = DateTime.Parse(myString);

and back into a proper to string

myTime.ToString("yyyy-MM-dd HH:mm:ss");

Or just read it into a datetime and cut out the middleman.