Doesn't look like the formatting worked on the last one. Just an quick example using the sqlite3 CLI:db=/tmp/test.dbsqlite3 $db "create table t(id integer primary key,ts text default (datetime('localtime','now')));"for x in "'no_date'" "'invalid_date'" "NULL" "CURRENT_TIMESTAMP" "DEFAULT"; do????sqlite3 $db "insert into t(ts) values($x);"donesqlite3 $db "select * from t;" Error: near "DEFAULT": syntax error1|no_date2|invalid_date3|4|2015-11-24 19:06:26
- [sqlite] INSERT DEFAULT literal-value chromedou...@yahoo.com
- [sqlite] INSERT DEFAULT literal-value Clemens Ladisch
- [sqlite] INSERT DEFAULT literal-value chromedou...@yahoo.com
- [sqlite] INSERT DEFAULT literal-value chromedou...@yahoo.com
- [sqlite] INSERT DEFAULT literal-va... Bernardo Sulzbach
- [sqlite] INSERT DEFAULT literal-va... R Smith
- [sqlite] INSERT DEFAULT liter... chromedou...@yahoo.com
- [sqlite] INSERT DEFAULT l... R Smith
- [sqlite] INSERT DEFAU... chromedou...@yahoo.com
- [sqlite] INSERT DEFAULT liter... chromedou...@yahoo.com