fritz
10/23/2020, 4:04 PMSELECT datetime(unix_time, 'unixepoch', 'localtime') FROM time;
Esteban
10/23/2020, 4:08 PMfritz
10/23/2020, 4:10 PMSELECT datetime(myColumn, 'InputTimeFormat', 'OutputTimeModifier') FROM table;
Esteban
10/23/2020, 4:11 PMfritz
10/23/2020, 4:11 PMdatetime(...) == strftime('%Y-%m-%d %H:%M:%S', ...)
Esteban
10/23/2020, 4:17 PMfritz
10/23/2020, 5:30 PMSELECT 'true' AS within_last_30_days WHERE myColumn < datetime('now', '-1 month');
seph
10/23/2020, 6:46 PMdatetime
function is pretty overloaded. that list of modifiers comprises date addition, truncation, and some very limited parsing