title: How to change date for SQL table (using phpmyadmin)?
body: <p>I'm having trouble understanding how to manipulate the format of dates in SQL.  I created a column and set the type to <code>date</code>. The default format seems to be <code>yyyy-mm-dd</code>.  I would prefer a format like <code>Jan 1, 2015</code>.  Is it best to keep the actual data stored in SQL in the seemingly standard <code>yyyy-mm-dd</code> format and convert it from there?</p>
  
  <p>In my case, I want to create select (dropdown) html forms that are based off my SQL date data.  But I'd like the dates to be displayed in the <code>Jan 1, 2015</code> format.  So it seems I would need to convert the SQL data into my desired format, and then when submitting back to SQL I would need to re-convert it into the standard format.  For the latter portion, the following code seems to work.  But how do I accomplish the former task of taking <code>yyyy-mm-dd</code> and converting it to my preferred format?</p>
  
  <pre><code>$myinput='Jan 1, 2015'; 
  
  $sqldate=date('Y-m-d',strtotime($myinput)); 
  
  echo $sqldate; 
  </code></pre>