Ron Aaron wrote:
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.
Changes to implement this capability are already in the
works and will be available within the next two months.
Stay tuned...
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
