title: How to subtract Time Column from DateTime Column in SQL?
body: <p>I have <code>Crea_Date</code> column which is a <code>DateTime</code> Column. I want to subtract the value in the <code>IST</code> column from <code>crea_date</code> Column and return a new column with the <code>DateTime</code> Value in it. My sample data is like this:</p>
  
  <pre><code>States  crea_date               IST
  AB      2014-12-30 15:01:00.000 12:30:00.0000000
  AK      2014-12-29 16:32:00.000 10:30:00.0000000
  AZ      2014-12-18 16:07:00.000 11:30:00.0000000
  </code></pre>
  
  <p>Thanks in Advance</p>