[sqlite] Using expressions for 'DEFAULT

[Ron Aaron]

I would like to have the default for a date field be the current date.  Right
now, I am using a post-insert trigger and modify the date; but I was hoping to
be able to use the 'default' clause of the table schema.

However, this statement is not parsed by SQLite:

CREATE TABLE a ( b datetime DEFAULT date('now'));

Is there a way to do what I intend using DEFAULT?  The docs don't seem to have
information on this.

Thanks,
Ron