title: Concatenate date and string to create datetime in SQL
body: <p>I need to concatenate a datetime and a time field in SQL to a single date time.</p>
  
  <p>e.g I have a datetime of 2017-09-05 00:00:00.000 and a string time of 11:00. What I want is a single field in a view of 2017-09-05 11:00:00.000</p>
  
  <p>I have tried casting the datetime to a date and then concatenate the new date and string date field together but this doesn't work. </p>
  
  <p>To cast the datetime I am using: <code>CAST(dtDate AS DATE) AS dtNewDate</code> which works fine. When I then use: <code>CAST(dtNewDate + szTime AS datetime) AS dtNewDateTime</code> the creation of the view works fine but selecting the top 1000 returns a "conversion failed when converting date and/or time from character string."</p>
  
  <p>Is there an easier way to do this or can anyone offer some advise (other than storing the date and time in a single datetime field in the first place as it is populated by a third party application which I do not have access to change)</p>