sqlite 日期类型
发布时间:2020-12-12 19:38:38 所属栏目:百科 来源:网络整理
导读:SELECT * from msgselect * from msg where datetime(startDate)=datetime('2015-09-20')select * from msg where datetime(endDate)datetime('2015-09-22')select * from msg where datetime(endDate)datetime('2015-09-22')SELECT datetime(endDate,'local
SELECT * from msg select * from msg where datetime(startDate)=datetime('2015-09-20') select * from msg where datetime(endDate)>datetime('2015-09-22') select * from msg where datetime(endDate)<datetime('2015-09-22') SELECT datetime(endDate,'localtime') as Time from msg SELECT datetime('now','localtime') as Time from msg SELECT strftime('%Y:%m:%d','now','localtime') as Time from msg SELECT strftime('%m','now')as Time from msg select * from msg where strftime('%m',endDate)=strftime('%m','2015-08-01') 转载 http://blog.sina.com.cn/s/blog_60539d040101b5fk.html </pre><p></p><p>创建数据库</p><p></p><pre name="code" class="java">CREATE TABLE msg ( _id INTEGER primary key autoincrement,id TEXT,startDate TEXT,endDate TEXT,title TEXT,comment TEXT,url TEXT,read TEXT); 插入测试数据 insert into msg (id,startDate,endDate,title,comment,url,read) values (101,'2015-09-20','2015-09-23','testtile','testcomment','testurl','testread'); insert into msg (id,read) values (102,'2015-09-24',read) values (103,'2015-09-25','testread'); insert into msg (id,'2015-05-20','2015-08-25','testread'); 查询语句: (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |