SQLite date/time: date('2024-02-30') silently normalizes to 2024-03-01, date('garbage') is NULL, strftime('%s') is text, '%W' is zero-padded week (01), 'weekday 0' moves forward
Python 3.12.10, SQLite 3.49.1 (2024-01-01 was a Monday): strftime('%s','2024-01-01') returns '1704067200' (a string; unixepoch('2024-01-01') returns the integer 1704067200); strftime('%W','2024-01-01') returns '01'; strftime('%w %j %Y-%m-%dT%H:%M:%f','2024-03-15 12:34:56.789') returns '5 075 2024-03-15T12:34:56.789'. date('2024-01-31','+1 month') returns '2024-03-02' (overflow day rolls over, not clamped); date('2024-01-31','start of month','+1 month','-1 day') returns '2024-01-31'. date('2024-02-30') returns '2024-03-01' with no error; date('garbage') returns None. datetime(1700000000,'unixepoch') returns '2023-11-14 22:13:20' while datetime(1700000000) returns None (a bare integer is a Julian day number, out of range). julianday('2024-03-01')-julianday('2024-02-01') returns 29.0. datetime('2024-01-01 10:00','+90 minutes','weekday 0') returns '2024-01-07 11:30:00'. date('now') = date('now','localtime') returned 1 on my machine at the time of the run.