sqllite 数据库中建表带有时间类型字段，并进行查询

 CREATE TABLE speakalarm2([ID] INTEGER PRIMARY KEY,[IDCardNo] VARCHAR (50),[info] TEXT,[CreatedTime] TimeStamp NOT NULL DEFAULT (datetime('now','localtime')));

 INSERT INTO speakalarm2([IDCardNo],[info]) VALUES('eeed','出入门37号非法进入报警'); 

   SELECT info,CreatedTime from speakalarm2 where CreatedTime > '2020-10-05 14:48:50' and CreatedTime< '2020-10-05 14:51:00' 

 

info    CreatedTime 出入门20非法进入报警    2020-10-05 14:50:33 出入门20非法进入报警    2020-10-05 14:50:42

 SELECT info,CreatedTime from speakalarm2

info    CreatedTime 出入门4非法进入报警    2020-10-05 14:48:32 出入门20非法进入报警    2020-10-05 14:50:33 出入门20非法进入报警    2020-10-05 14:50:42 出入门56非法进入报警    2020-10-05 14:51:21 出入门68非法进入报警    2020-10-05 14:51:35 出入门37非法进入报警    2020-10-05 14:51:47