Hi
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
--
Regards
John McMahon
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
