title: Combining date and time fields in SQL Server
body: <p>I have 3 columns in a table in SQL server 2005.</p>
  
  <p>Column A is datetime, Column B is character field  and Column C is again a datetime field.</p>
  
  <p>How can I combine column A and Column B into column C field?</p>
  
  <p>For example, 
  column A (datetime) has a value '2004-01-05 00:00:00.000' , 
  Column B (character 8) has a value '09:30:00'</p>
  
  <p>I would like to combine these fields and store this value in Column C
  and in this example column C would appear as '2004-01-05 09:30:00'</p>
  
  <p>Thanks</p>