[Fwd: Re: [sqlite] How do I create a field with default current_timestamp]

[Bert Verhees]

sqlite> Insert into TemperatureData (tempt) values(86.0);
sqlite> select * from temperaturedata;
40.2|
86|CURRENT_TIMESTAMP

--- Begin Message ---

Brass Tilde wrote:

Create table TemperatureData ( Tempt real, TimeStamp default

CURRENT_TIMESTAMP);

Insert into TempertaureData values( 40.2, NULL);

Try specifying the Tempt field and it's value only.  SQLite may be
interpreting the NULL as a supplied value and thus not inserting the default
value.

        Insert into TemperatureData (tempt) values(86.0);

Don't have SQLite on the machine here, or I would check it myself.

sqlite> Create table TemperatureData ( Tempt real, TimeStamp default CURRENT_TIMESTAMP);
sqlite> Insert into TempertaureData values( 40.2, NULL);
SQL error: no such table: TempertaureData
sqlite> Insert into TemperatureData values( 40.2, NULL);
sqlite> select * from temperaturedata;
40.2|


--- End Message ---