01. How to get the date difference results in days using SQL Lite?
Example 1: Payment Date - Invoice Date
- Payment Date = 05/05/2016
- Invoice Date = 15/03/2016
- Date differences (in days) = 51
| Julianday(Date) |
|---|
|
(julianday(Date(PaymentDate)) - julianday(Date(InvoiceDate))) |