Petite Abeille <petite.abei...@gmail.com> wrote: > Say, I would like to convert that date to a julian day: > >> select julianday( date( 1030561675, 'unixepoch', 'utc' ) ); > 2452514.5 > > Oooops... where does that .5 comes from?
In Julian calendar, 0 represents noon, and .5 represents midnight. > I was more expecting the following: >> select cast( julianday( date( 1030561675, 'unixepoch', 'utc' ) ) as integer >> ); > 2452514 What was that expectation based on? > So how come does julianday take the time part of date into consideration even > when it's not provided? It doesn't. > JD 2452514.500000 is > CE 2002 August 28 00:00:00.0 UT Wednesday > > JD 2452514.000000 is > CE 2002 August 27 12:00:00.0 UT Tuesday Looks OK to me. What again seems to be the problem? > Or did I miss something? Apparently. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
