Sqlite数据库 查询获取两个日期之间相差多少天问题

Question

代码：SELECT julianday('2010-11-08 20:50:30')-julianday('2009-11-08 20:30:30') as t， 我想要返回的是整数天数，可是这样返回的是带小数的天数在oracle中用Trunc可以很轻松搞定。那么在sqlite中完整2个完整日期获取天数怎样才可以获取到是整数

SELECT TRUNC (TO_DATE('2010-11-08 20:50:30','YYYY-MM-DD hh24:mi:ss')
              - TO_DATE ('2009-11-08 20:30:30', 'YYYY-MM-DD hh24:mi:ss')
             ) tian
  FROM DUAL;

---

啥叫乐观－得瑟的最高境界

Answer 1

It's not sql server issue.

Answer 2

如果是SQL Server，我们可以使用datediff函数，比如：

select datediff(day,'2006-9-1','2006-10-1') as 相差天數,datediff(week,'2006-9-1','2006-10-1') as 相差周數

---

Thanks, Yoyo Yu

Answer 3

冰凌 sql,和oracle都好解决

最后自己搞定了

julianday(strftime('%Y-%m-%d','2010-11-28 20:50:30'))-julianday(strftime('%Y-%m-%d','2009-11-08 20:30:30'))

---

啥叫乐观－得瑟的最高境界