title: Remove seconds from datetime
body: <p>I have query as below:</p>
  
  <pre><code>select  
   lower(convert(varchar(10), GETDATE(), 101) +
   ' '+ 
   substring(convert(varchar(20), GETDATE(), 22),9,Len(GETDATE())))
  </code></pre>
  
  <p><strong>In this query i am getting result as:</strong></p>
  
  <pre><code>06/27/2014   6:23:57 pm
  </code></pre>
  
  <p>I just want to remove seconds (i.e. 57) from above.</p>
  
  <p>My intentded result is:</p>
  
  <pre><code>06/27/2014   6:23 pm
  </code></pre>
  
  <p>How can i obtain it??</p>
  
  <p>I tried adding Length in the query as:</p>
  
  <pre><code>select  
   lower(convert(varchar(10), GETDATE(), 101) +
   ' '+ 
   substring(convert(varchar(20), GETDATE(), 22),9,Len(GETDATE())+1))
  </code></pre>
  
  <p>But it didnt help.</p>
  
  <p>Plase help me.</p>