> Put parentheses around the strftime() function call:
>
> CREATE TABLE info(..., stamp DEFAULT (strftime('%f','now')))
>
> The extra parentheses are needed to avoid a parsing ambiguity in the
> SQL language.
>
> D. Richard Hipp
> d...@hwaci.com
Perfect!
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
assuredcommunications(tm)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
