title: How to concat date and time column into one and then convert it into EST format?
body: <p>If I have a df like the one shown below</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT `case_id` AS ID,`updt_dt` AS Update_date,`updt_tm` AS Update_time 
  FROM case_dly_snap 
  LIMIT 2&quot;
  </code></pre>
  <p>My df comes like below:</p>
  <p><a href="https://i.stack.imgur.com/8W4bx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8W4bx.png" alt="enter image description here" /></a></p>
  <p>where <code>update_date</code> is in date format and <code>update_time</code> is in string format.</p>
  <p>How can I convert it into one in a date+time format?</p>
  <p>Expected output</p>
  <p><a href="https://i.stack.imgur.com/buzPK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/buzPK.png" alt="enter image description here" /></a></p>