Hi there! I just spotted a typo in the SQLite documentation at http://www.sqlite.org/lang_datefunc.html "SQL As Understood By SQLite: Date And Time Functions"
In the "Examples" section, Compute the number of days since the signing of the US Declaration of Independent. SELECT julianday('now') - julianday('1776-07-04'); should better be Compute the number of days since the signing of the US Declaration of Independence. Moreover, according to its Wikipedia article, http://en.wikipedia.org/wiki/United_States_Declaration_of_Independence#Signing quote "Although the wording of the Declaration was approved on July 4, the date of its signing has been disputed. Most historians have concluded that it was signed nearly a month after its adoption, on August 2, 1776, and not on July 4 as is commonly believed." it might be safer to say Compute the number of days since the ratification of the US Declaration of Independence. :) Best wishes, Nicolas Kaiser _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users