[sqlite] datetime question

[YAN HONG YE]

create table test( Date datetime);
insert test now();
select date+2 as bbb,date-12 as cc from test;
the result is 
2014,2000
I wanna know how to add any day use sql command
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users