Re: [sqlite] Can't insert timestamp field with value CURRENT_TIME

2008-10-01 Thread Ribeiro, Glauber
SQLite Database Subject: Re: [sqlite] Can't insert timestamp field with value CURRENT_TIME On Sep 27, 2008, at 7:13 AM, Mark Wyszomierski wrote: > Hi, > > I'm trying to add a timestamp field to an existing table using the > following > statement: > >ALTER

Re: [sqlite] Can't insert timestamp field with value CURRENT_TIME

2008-09-30 Thread Dan
On Sep 27, 2008, at 7:13 AM, Mark Wyszomierski wrote: > Hi, > > I'm trying to add a timestamp field to an existing table using the > following > statement: > >ALTER TABLE test ADD COLUMN lunchtime TIMESTAMP NOT NULL DEFAULT > CURRENT_TIME > > this fails with the following error: > >Cann

[sqlite] Can't insert timestamp field with value CURRENT_TIME

2008-09-26 Thread Mark Wyszomierski
Hi, I'm trying to add a timestamp field to an existing table using the following statement: ALTER TABLE test ADD COLUMN lunchtime TIMESTAMP NOT NULL DEFAULT CURRENT_TIME this fails with the following error: Cannot add a column with non-constant default Ok that makes sense - but why can