title: how to convert date in English and French
body: <p>I am trying to store formatted display dates in my tables.  For example, I have a date as 20150621 and I want it as June 21, 2015 and 21 juin 2015 (for French). </p>
  
  <p>I have a  query: <code>convert(varchar(12),cast([datecolumn]) as datetime),107)</code></p>
  
  <p>This outputs: Jun 21,2015 , but I need June 21,2015 and also French date.</p>
  
  <p>I am using Sql 2005, so format doesn`t work in it.</p>