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...
Oo
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
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 DEFAUL
3 matches
Mail list logo