title: How to present Date in SQL without leading zeros
body: <p>Is there a SQL format to remove leading zeros from the date?</p>
  
  <p>Like if the date is <code>01/12/2015</code> to present it as <code>1/12/2015</code>, and <code>01/01/2016</code> should be shown as <code>1/1/2016</code> etc  </p>
  
  <p>The entire date normally contains <code>dd/MM/yyyy HH:mm:ss</code>. I need to remove those redundant leading zeroes without changing the rest of information.</p>
  
  <p>Currently I use query containing something like this:  </p>
  
  <pre><code>convert(varchar, dateadd(hh, " + 2 + " , o.start_time), 103)) + ' '  
  left(convert(varchar, dateadd(hh, " + 2 + " , o.start_time), 108), 110)  
  </code></pre>
  
  <p>I'm working with SQL Server 2008</p>