Thanks for the reply. It would be the case of specifying a default value among
other columns but not wishing to remove it from the inserted fields -- not just
because I'm lazy, but also to reuse that same INSERT statement for other values.
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 error
1|no_date
2|invalid_date
3|
4|2015-11-24 19:06:26
