I have the following table create table test ( test_id integer not null, last_mod_date default current_timestamp, stuff, primary key(test_id));
if I run the following insert into test(stuff) values('junk'); I get the string literal current_timestamp in my last_mod_date columns value and not the expected current UTC time. Is this a bug or am I missing something. I can use a trigger to emulate the behavior of the default constraint. I am using slqlite 3.0.8 Dennis Ryan