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

Reply via email to