title: concatenate two columns with date and time in sql?
body: <p>I have two columns as <code>orderdate(03/02/2011)</code> and <code>ordertime(10.34 am)</code> in which i have to concatenate these two columns and show it in another column as datetime values<code>(03/02/2011 10:34:16.190)</code>....</p>
  
  <p>any suggestion?</p>