摘要： sql中datadiff的应用SELECT julianday('2012-07-26')-julianday('2012-07-25')>0 as cha,julianday(strftime('%Y-%m-%d','2012-07-26 0:00:00'))-julianday(strftime('%Y-%m-%d',votedate)) as ch1,* from userinfo where ID=20并发写入的解决方法SQLite使用全局事务避免写入冲突2009-12-19 13:32http:// 阅读全文