title: Using T-SQL, how to convert date format mmm-dd-yyyy to yyyy-mm-dd
body: <p>Using TSQL, what's the most efficient way to convert a datatype string formatted date 'mmm-dd-yyyy' to  data type date format 'yyyy-mm-dd'</p>
  
  <p>Example: </p>
  
  <p>Original date: Jan-31-2013</p>
  
  <p>Converted date: 2013-01-31</p>
  
  <p>I was looking for the conversion in this document but no success. <a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a></p>