title: Convert a string to smalldatetime
body: <p>I have a string arranged in a way that would match the format yyyy-dd-MM HH:mm:ss
  It might look like this <code>2010-20-12 13:30:00</code></p>
  
  <p>I need to insert this into a smalldatetime column in SQL Server. The format of the column is
  yyyy-MM-dd HH:mm:ss</p>
  
  <p>I need the string to look like this <code>2010-12-20 13:30:00</code> or else SQL Server will get the month and day confused.</p>
  
  <p>Thanks for your thoughts</p>