title: How to concatenate a string and GETDATE() in MSSQL
body: <p>I need to insert a string (a comment) which should include a date. What I need is basically the following simple operation:</p>
  
  <pre><code>INSERT INTO [Table_1]
             ([textColumn])
       VALUES
             ('Date: ' + GETDATE())
  GO
  </code></pre>
  
  <p>This however, returns the following error: <em>Conversion failed when converting date and/or time from character string.</em></p>
  
  <p>Any quick fixes? </p>