SQLite 按时间段查询日期 显示数据问题
--创建表
CREATE TABLE ReturnGoodsMains (
ReturnSysID VARCHAR NOT NULL,
ReturnDate VARCHAR,
PRIMARY KEY ( ReturnSysID )
);
--添加数据
insert into ReturnGoodsMains (ReturnSysID,ReturnDate) values('63X01105030497201212020001','2012-12-2 16:14:49');
insert into ReturnGoodsMains (ReturnSysID,ReturnDate) values('63X01105030497201212020002','2012-12-1 16:15:43');
insert into ReturnGoodsMains (ReturnSysID,ReturnDate) values('63X01105030497201212020003','2012-12-9 16:16:12');
insert into ReturnGoodsMains (ReturnSysID,ReturnDate) values('63X01105030497201212020004','2012-12-6 16:18:18');
insert into ReturnGoodsMains (ReturnSysID,ReturnDate) values('63X01105030497201212020005','2012-12-9 16:19:30');
insert into ReturnGoodsMains (ReturnSysID,ReturnDate) values('63X01105030497201212020006','2012-12-9 16:20:01');
问题来了:
select * from ReturnGoodsMains where datetime(ReturnDate)>='2012-12-2 00:00:00' and datetime(ReturnDate)<'2012-12-3 00:00:00' ;
执行后无结果;
select * from ReturnGoodsMains where ReturnDate>='2012-12-2 00:00:00' and ReturnDate<'2012-12-3 00:00:00' ;
执行后显示结果:63X01105030497201212020001 2012-12-2 16:14:49 正确
select * from ReturnGoodsMains where ReturnDate>='2012-12-2 00:00:00' and ReturnDate<'2012-12-10 00:00:00' ;
执行后没有结果。请问大家这是怎么回事,弄两天了就是查不出来。