title: How to format datetime as M/D/YYYY in SQL Server?
body: <p>To convert a <code>datetime</code> to <code>MM/DD/YYYY</code>, this works:</p>
  
  <pre><code>declare @datetime datetime = '2015-01-01'
  select convert(varchar(10),convert(date,@datetime),101)
  </code></pre>
  
  <p>This evaluates to <code>01/01/2015</code>. How can I have the date convert to <code>1/1/2015</code> instead?</p>
  
  <p>Nothing on <a href="http://www.sql-server-helper.com/tips/date-formats.aspx" rel="noreferrer">http://www.sql-server-helper.com/tips/date-formats.aspx</a> matches the <code>M/D/YYYY</code> format.</p>