title: sqlite - daydifference between two date fields
body: <p>Just learning SQLite...I run this query:</p>
  
  <pre><code>select guests.[GUEST_NAME],guests.[GUEST_SURNAME],guest_data.[START_DATE],guest_data.[END_DATE]
  from guests
  INNER JOIN guest_data
  ON guests.guest_id=Guest_data.guest_id
  order by  guests.[GUEST_SURNAME] ASC
  </code></pre>
  
  <p>This works OK but I need to learn : How can I get extra field as DAYS
  as datediff between start_date,end_date ? I tried adding :</p>
  
  <pre><code> select guests.[GUEST_NAME],guests.[GUEST_SURNAME],guest_data.[START_DATE],guest_data.[END_DATE],DAYS as Daysbetween(guest_data.start_date,guest_data.end_date)
  </code></pre>
  
  <p>but it will not work. Also how would this query be written in delphi?  </p>