Re: [sqlite] Using expressions for 'DEFAULT
On Sun, October 31, 2004 3:58, D. Richard Hipp said: >> However, this statement is not parsed by SQLite: >> >> CREATE TABLE a ( b datetime DEFAULT date('now')); > Changes to implement this capability are already in the > works and will be available within the next two months. > Stay tuned... Ooh, thanks! I am anxiously looking forward to it ... Ron -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853 CB42 3ECF 9259 AD29 415D
Re: [sqlite] Using expressions for 'DEFAULT
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