title: How to convert Varchar to Date?
body: <p>I have a table - Order and I have a field "Order_Date" which is in Varchar format - '20150804'. </p>
  
  <pre><code>select order_date from order
  output- 20150804
  </code></pre>
  
  <p>I want to convert order_date- <strong>'20150804'</strong>  into Date format- <strong>'07-SEP-15'</strong></p>