title: Concatenate Date and Time as DATETIME in SQL Server
body: <p>I'm having a trouble in combining date and time to <code>DATETIME</code>. I have an existing table with data so I can't change it to <code>Datetime2</code>.</p>
  
  <pre><code>DECLARE @t1 TABLE(StartDate DATE, StartTime Time)
  
  INSERT INTO @t1 
  VALUES('2018-02-28','08:00:00')
  
  SELECT 
      CAST(CONCAT(StartDate, ' ', StartTime) AS DATETIME) 
  FROM @t1
  </code></pre>
  
  <p>The error shown is:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>