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
