title: CAST Date and Time in SQL Server
body: <p>In my Data Table I have a Date Column Format = <code>yyyy/mm/dd</code> and a Time column Format <code>hh:mm:ss</code>. I am trying to concat the two so I can use it in a calendar. I keep getting an error. Here is my qry: 
  <code>CAST(T0.[Date]) AS Date) + CAST(T0.[Time]) AS Time(7))</code></p>
  
  <p>Where am I going wrong?</p>