title: How to convert DateTime to VARCHAR() without dashes and colons
body: <p>I have a column which has data as such: <code>2014-08-15 15:11:00</code></p>
  
  <p>I want to run a select on this column and end up with this: <code>20140815151100</code></p>
  
  <p>Basically <code>YYYYMMDDhhmmss</code>.</p>
  
  <p>I tried to do a <code>CAST()</code> and <code>CONVERT()</code> to <code>VARCHAR()</code> and then remove the dashes &amp; colons but when I do that, I end up with this: <code>Aug 15 2014  3:11PM</code></p>
  
  <p>And that's not what I want. Can someone give me a hand?</p>