title: MySQL - Date Column Format
body: <p>I am familiar with <code>DATE_FORMAT</code> function which can display the the record from my date field in the format specified. However, I would like to create a table with a date field that only accepts my format.
  <br><br>
  Here's what I have done so far:</p>
  
  <pre><code>CREATE TABLE test_table (
  id INT AUTO_INCREMENT, 
  f_name VARCHAR(40) NOT NULL, 
  l_name VARCHAR(25) NOT NULL, 
  date_hired DATE NOT NULL
  );
  </code></pre>
  
  <p>Inserting a record with a date_hired value of '2013-03-01' will be inserted as '1/03/2013 12:00:00 AM' which is far from my expected result (I would like the format the way it was inserted). Any feedback? Did I miss something?
  <br><br>
  Thanks,<br>
  Michael</p>