SELECT customersince, Date() AS CurrentDate, Date() - CustomerSince AS DaysExisting, -- not correct julianday('now') AS JDayCurrent, julianday(customersince) AS JDayCust, ROUND(julianday('now') - julianday(customersince),0) AS DaysExisting, strftime('%J', 'now'), -- this is identical to julianday('now' strftime('%m', 'now'), strftime('%Y', 'now') AS CurrentYear, strftime('%Y', customersince) AS CustSinceYear, strftime('%Y', 'now') - strftime('%Y', customersince) AS YearsExist, --datetime() AS DateTimeFunction, FROM Customers