SELECT cast(julianday('2014-11-16')-julianday('2014-11-17') as integer) AS aaa

--------------------------------------------------------

aaa

-1

SELECT date('now'); --2014-12-16 select date('now','+1 days') as weekdate; --2014-12-17 select datetime('now','localtime'); --2014-12-16 14:39:07