title: Convert DateTime in C# to yyyy-MM-dd format and Store it to MySql DateTime Field
body: <p>I am trying to convert <code>DateTime</code> format to <code>yyyy-MM-dd</code> format and store it to <code>DateTime</code> object. But it gives me the System <code>DateTime</code> format that is <code>MM/dd/yyyy</code>.<br>
  I am using following code to convert.  </p>
  
  <pre><code>string dateTime = DateTime.Now.ToString();
  string createddate = Convert.ToDateTime(dateTime).ToString("yyyy-MM-dd h:mm tt");         
  DateTime dt = DateTime.ParseExact(createddate, "yyyy-MM-dd h:mm tt",CultureInfo.InvariantCulture);
  </code></pre>
  
  <p>but non of the above line converts into the specified format.<br>
  Can any one help to solve this.</p>
  
  <p>I am getting the DateTime from one application and passing this object to other application and That application is storing that date into MySql's DateTime field which is in the format "yyyy-MM-dd".<br>
  This is why I have posted this question.  </p>
  
  <p>Project 1 has class from that I am getting the date.
  and the processor class which is the middle ware of the application it processes the DateTime format to convert in specific format. And passes to the Other project which consumes the DateTime and stores that in the MySql field.</p>