CREATE TABLE Logs(
RecordTime timestamp NOT NULL DEFAULT datetime(CURRENT_TIMESTAMP,'localtime'),
SNo varchar(20),Type varchar(50),Message text,AppName varchar(50))没有办法让时间直接以timestamp进去,用了datetime()了以后,毫秒直接被阉割了
RecordTime timestamp NOT NULL DEFAULT datetime(CURRENT_TIMESTAMP,'localtime'),
SNo varchar(20),Type varchar(50),Message text,AppName varchar(50))没有办法让时间直接以timestamp进去,用了datetime()了以后,毫秒直接被阉割了
你自己在增加个字段专门记录毫秒不就行了,整型记录毫秒就行了.
...> RecordTime timestamp DEFAULT (strftime('%Y-%m-%d %H:%M:%f','now')),
...> SNo varchar(20)
...> );
sqlite> insert into Logs (SNo) values ('a');
sqlite> insert into Logs (SNo) values ('b');
sqlite> select * from logs;
2009-06-16 11:17:31.391|a
2009-06-16 11:17:34.859|b
sqlite>[/code]