Hello,
In the documentation for column constraints, there is an option called "default" which could take the text "current_timestamp" as its value. Supposedly, this will populate the column with the current time and date. However, when I attempt to use this, my column is simply populated with the literal text "current_timestamp" rather than the expected time value.
Is this feature working yet? Or have I defined my column incorrectly? I'm using sqlite 3.0.7 on Max OS X 10.3.6.
sqlite> create table sample (
...> name text,
...> inserted timestamp default current_timestamp
...> );
sqlite> insert into sample (name) values ('Joe');
sqlite> select * from sample;
Joe|current_timestamp
sqlite>
Regards, Joe
