title: Convert DateTime to yyyyMMddHHmm in T-SQL
body: <p>Is something like the below my only option?  I was hoping there was a better, cleaner, way to accomplish this.  </p>
  
  <p>This being, my dates need to end up formatted like so --> 201301080105 for 1:05 AM on 1/8/13.</p>
  
  <p><code>SELECT SUBSTRING(REPLACE(CONVERT(varchar, GETDATE(), 111), '/','') + REPLACE(CONVERT(varchar, GETDATE(), 108), ':',''),0,13) AS 'My Formatted Date'</code></p>