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