title: how to format getdate into YYYYMMDDHHmmSS
body: <p>In SQL Server how do I format <code>getdate()</code> output into <code>YYYYMMDDHHmmSS</code> where <code>HH</code> is 24 hour format?</p>
  
  <p>I've got the <code>YYYYMMDD</code> done with </p>
  
  <pre><code>select CONVERT(varchar,GETDATE(),112)
  </code></pre>
  
  <p>but that is as far as I got.</p>
  
  <p>Thanks.</p>