title: Help with mysql str-to-date
body: <p>I cannot get this to work. I want to use str_to_date to convert a date string. Here is my insert statement.</p>
  
  <pre><code>INSERT INTO cars(carno, color, date) VALUES ('1', 'brown', STR_TO_DATE('$date', 'm%/%d/%Y'))
  </code></pre>
  
  <p>Can someone please tell me where I am going wrong? The date in my variable is 12/12/2002</p>
  
  <p>Anyone???</p>