Is there a way to set a default timestamp with fractional seconds?
This works but doesn't give fractional seconds: CREATE TABLE info(k, v, stamp DATETIME default CURRENT_TIMESTAMP); This gives a syntax error (obviously) but expresses my intent: CREATE TABLE info(k, v, stamp DATETIME default strftime('%Y-%m-%d %H:%M:%f', 'now')); RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users