.sqlite_history

SELECT * FROM work
;s
SELECT * FROM works;
SELECT * FROM notifications;
SELECT * FROM notifications;
SELECT * FROM notifications;
SELECT * FROM notifications;
SELECT * FROM notifications;
\q
;
quit;
exit
;
quit;
end
;
exit;
;
;
.exit
SELECT * FROM notifications;
DELETE FROM work WHERE DATE(due_at) >= DATE('now'); DELETE FROM jobs;
DELETE FROM works WHERE DATE(due_at) >= DATE('now'); DELETE FROM jobs;
exit
;
quit;
quit
;
\q
;
DELETE FROM works WHERE DATE(due_at) >= DATE('now'); DELETE FROM jobs;
SELECT * FROM jobs;
SELECT * FROM jobs;
SELECT * FROM jobs;
SELECT * FROM jobs ORDER BY available_at;
SELECT * FROM jobs ORDER BY available_at ASC LIMIT 1;
SELECT DATE(available_at) FROM jobs ORDER BY available_at ASC LIMIT 1;
SELECT DATETIME(available_at / 1000, 'unixepoch') FROM jobs ORDER BY available_at ASC LIMIT 1;
SELECT DATETIME(available_at / 1000, 'unixepoch', 'localtime') FROM jobs ORDER BY available_at ASC LIMIT 1;
SELECT DATETIME(available_at, 'unixepoch', 'localtime') FROM jobs ORDER BY available_at ASC LIMIT 1;
SELECT DATE('now')
;
SELECT DATETIME('now')
;
SELECT * FROM jobs WHERE DATETIME(avilable_at) <= DATETIME('now')
;
SELECT * FROM jobs WHERE DATETIME(available_at) <= DATETIME('now');
SELECT * FROM jobs WHERE DATETIME(available_at) <= CURRENT_TIMESTAMP;
SELECT * FROM jobs WHERE available_at <= CURRENT_TIMESTAMP;
SELECT DATETIME(available_at, 'unixepoch', 'localtime') FROM jobs WHERE available_at <= CURRENT_TIMESTAMP;
SELECT DATETIME(available_at, 'unixepoch', 'localtime') FROM jobs WHERE available_at >= CURRENT_TIMESTAMP;
SELECT DATETIME(available_at, 'unixepoch', 'localtime') FROM jobs WHERE available_at < CURRENT_TIMESTAMP;
SELECT DATETIME(available_at, 'unixepoch', 'localtime') FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < CURRENT_TIMESTAMP;
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), CURRENT_TIMESTAMP FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < CURRENT_TIMESTAMP;
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), DATETIME(timestamp, 'localtime') FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < DATETIME(timestamp, 'localtime');
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), DATETIME(timestamp, 'localtime') FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < DATETIME('now', 'localtime');
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), DATETIME('now', 'localtime') FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < DATETIME('now', 'localtime');
DELETE FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < DATETIME('now', 'localtime');
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), DATETIME('now', 'localtime') FROM jobs WHERE DATETIME(available_at, 'unixepoch', 'localtime') < DATETIME('now', 'localtime');
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), DATETIME('now', 'localtime') FROM jobs ORDER BY available_at ASC;
SELECT DATETIME(available_at, 'unixepoch', 'localtime'), DATETIME('now', 'localtime') FROM jobs ORDER BY available_at ASC LIMIT 10;