T-SQL concatenate & convert string to date time
<p>I have a table (once again implemented by the bio-metric software) that stores date and time as strings in different columns.</p>
<p>Date column stores date like <code>20160128</code> for <code>January 18 2016</code> and the time column stores the time like <code>220747</code> (<code>10:07:47 PM</code>).</p>
<p>How I can concatenate both the strings and convert to a valid datetime value?</p>
<p>I have referred few of the other questions asked here already and found many of them only refers to the date part, missing time factor</p>
<p><a href="https://i.stack.imgur.com/M0vG4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/M0vG4.png" alt="Table structure" /></a></p>