title: Convert a date value in SQL Server 2008
body: <p>I have a value as <code>2013-01-18</code> in this format as date datatype, I need to convert this as <code>Fri, Jan 18, 2013</code> in SQL Server 2008.</p>
  
  <p>How do I convert ?</p>