Zbigniew Baniewski wrote:
> #v+
> SQLite version 3.5.6
> Enter ".help" for instructions
> sqlite> select date('now');
> 2008-03-28
> sqlite> select date('now')-14;
> 1994
> sqlite>
I think what you want is date math:
sqlite> SELECT date('now','-14 days');
2008-03-14
All well documented on the wiki:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
