title: SQL insert datediff
body: <p>I am trying to run a SQL <code>INSERT</code> that will calculate a <code>DATEDIFF</code> on two dates.</p>
  
  <p>Does anybody know if you can use <code>DATEDIFF</code> on SQL <code>INSERT</code> command?</p>
  
  <p>I want column duration to be calculate from dateFrom and dateTo at time of inset</p>
  
  <pre><code>INSERT INTO liveRequests (customerID, destination, departure, dateFrom, dateTo, exactDate, rooms, adults, children, budgetMax, activeRequest, duration)
  
  VALUES (@customerID,@destination,@departure,@dateFrom,@dateTo,@exactDate,@rooms,@adults,@children,@budgetMax,@activeRequest, DATEDIFF('day',@dateFrom,@dateTo))
  </code></pre>