title: SQL Difference between two times in seconds
body: <pre><code>SELECT   Warehouses.Name,
           RIGHT(CONVERT(VARCHAR,AirwayBillTrucks.CheckOutTime,100),7) AS CheckOutTime,
           RIGHT(CONVERT(VARCHAR,AirwayBillTrucks.ReturnTime,100),7) AS ReturnTime
  </code></pre>
  
  <p>That is my piece of code, CHECKOUTTIME and RETURNTIME used to be DATETIME
  DD-DD-YYYY HH-MM-SS but I converted them into TIME HH-MM-SS tt which is fine for me. Now I need to now the difference between those two columns in seconds, </p>