On Wed, May 22, 2013 at 10:05 AM, Stephan Buchert <stephanb...@gmail.com>wrote:
> 1) do nothing, or maybe just document more clearly, that the julianday > in Sqlite, for date/time input in UTC, returns JD(UTC) in IAU > terminology, which, for example, does give time differences (or nr of > days elapsed since epoch) ignoring leap seconds and is off by about > 1 minute with respect to astronomical JD. > The final two sentences of the documentation ( http://www.sqlite.org/lang_datefunc.html), under the "Caveats and Bugs" heading, says as much: specifically that SQLite assumes that every day is exactly 86400 seconds long. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
