SELECT date and time

Date And Time Functions

SELECT 'date', date();
SELECT 'time', time();
SELECT 'datetime', datetime();
SELECT 'julianday',julianday();
SELECT 'unixepoch', unixepoch();
SELECT 'strftime', strftime();
SELECT 'strftime with param', strftime('%Y-%m-%d %H:%M:%S');
--SELECT timediff('%Y');

$ sqlite3 < examples/date-and-time.sql

date|2026-05-04
time|13:59:26
datetime|2026-05-04 13:59:26
julianday|2461165.0829416784
unixepoch|1777903166
strftime|
strftime with param|2026-05-04 13:59:26