CODEWITHSUNDEEP
delphisqlitedelphi-xe4
user763539
user763539

Reputation: 3699

sqlite - daydifference between two date fields

Just learning SQLite...I run this query:

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

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 :

 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)

but it will not work. Also how would this query be written in delphi?

Upvotes: 2

Views: 2221

Answers (1)

Oleg Belousov
Oleg Belousov

Reputation: 10121

select guests.[GUEST_NAME],guests.[GUEST_SURNAME],guest_data.[START_DATE],guest_data.[END_DATE],
julianday(guest_data.end_date) - julianday(guest_data.start_date) AS DAYS_INTERVAL
from guests
INNER JOIN guest_data
ON guests.guest_id=Guest_data.guest_id
order by  guests.[GUEST_SURNAME] ASC

Please try this structure of syntax and keep us posted. Your interval in days should return as a separate column in the result set named "DAYS_INTERVAL"

Upvotes: 3

Related Questions