Fast Report - SQL Lite Functions Commonly Use

From eStream Software

Revision as of 01:45, 6 May 2016 by Csloo (talk | contribs) (Created page with "===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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)))

Retrieved from "https://wiki.sql.com.my/index.php?title=Fast_Report_-_SQL_Lite_Functions_Commonly_Use&oldid=5237"