On 20 May 2013, at 4:55am, Simon Slavin <slav...@bigfraud.org> wrote:
> I wonder if there's a difference between > > DEFAULT date('now') > > and > > DEFAULT (date('now')) Bah. Of course, you can't do either: <http://www.sqlite.org/lang_createtable.html> "An explicit DEFAULT clause may specify that the default value is NULL, a string constant, a blob constant, a signed-number, or any constant expression enclosed in parentheses. An explicit default value may also be one of the special case-independent keywords CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP." No variable expressions at all, with a non-standard hack to allow time-sensitive values. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users