title: How to insert date in a table with a different format?
body: <p>My problem here is that I have a date value as <code>05/09/2013</code>  in a HTML text box which cannot be altered. </p>
  
  <p>Now sql only accepts date format as <code>yyyy/mm/dd</code>. so while inserting this textbox value into sql database it does not support this format and throws an exception. </p>
  
  <p>Therefore my question is how to insert a textbox value with different format into a sql database?</p>
  
  <p>For instance my code would look like </p>
  
  <pre><code>insert into table (date) value('"&amp; date&amp; "')
  </code></pre>
  
  <p>input box has a calender type textbox and sends a date in  <code>05/09/2013</code> format</p>