title: converting access datetime type to mysql type
body: <p>I am trying to convert an access datetime field to a mysdl format, using the following string:</p>
  
  <pre><code>select str_to_date('04/03/1974 12:21:22', '%Y %m %d %T');
  </code></pre>
  
  <p>While I do not get an error, I do not get the expected result, instead I get this:</p>
  
  <pre><code>+---------------------------------------------------+
  | str_to_date('04/03/1974 12:21:22', '%Y %m %d %T') |
  +---------------------------------------------------+
  | NULL                                              |
  +---------------------------------------------------+
  1 row in set, 1 warning (0.01 sec)
  </code></pre>
  
  <p>The access dates are in this format:</p>
  
  <pre><code>06.10.2008 14:19:08
  </code></pre>
  
  <p>I am not sure what I am missing.</p>
  
  <p>As a side question, I am wondering if it is possible when importing a csv file to change the data in a column before? I want to replace the insert_date and update_date fields with my own dates, and I am not sure if it would be easier to do this before importing or after.</p>
  
  <p>Many thanks for assistance.</p>