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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
