title: Date format change to dd/mm/yyyy to dd mon yy in sql server
body: <p>I tried below query to get date format as <strong>25 Sep 2018</strong> but it is not converting the date type and actual date format is in <code>dd/mm/yyyy</code> format.
  Please help.</p>
  
  <pre><code>select convert(varchar, FOUNDEDYEAR, 108)FROM EDELGIVE_KYC_DETAILSS
  </code></pre>