[sqlite] Faulty "date" function

[Zbigniew Baniewski]

#v+
SQLite version 3.5.6
Enter ".help" for instructions
sqlite> select date('now');
2008-03-28
sqlite> select date('now')-14;
1994
sqlite>
#v-

Of course, proper answer should be: "2008-03-14" - shouldn't it?
-- 
                                pozdrawiam / regards

                                                Zbigniew Baniewski
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users