"John" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I want to (if possible) create a table with a default timestamp in a > format other than "YYYY-MM-DD ..." per example below. I have tried a > few variants but always get same error. > > Can this be done and if so, how? > > create table ( > custnum integer primary key not null, > note text, > stamp default (strftime('%s', current_timestamp)) > ); > SQL error: near "(": syntax error
SQLite complains about the very first opening paren, the one right after "create table". You are missing the table name, as in "create table tableName ...". Once this is fixed, your statement works as written. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
