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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
