On Sat, Sep 17, 2011 at 3:52 PM, Petite Abeille <petite.abei...@gmail.com>wrote:
> > > So how come does julianday take the time part of date into consideration > even when it's not provided? > > > > In SQLite: > > > select julianday( '2002-08-28' ); > 2452514.5 > *SNIP* > I was expecting a julian day number. SQLite's julianday function returned a > julian date (including a time portion). > > http://www.sqlite.org/lang_datefunc.html The julianday() function returns the Julian day<http://en.wikipedia.org/wiki/Julian_day>- the number of days... <emphasis> since noon </emphasis> in Greenwich on November 24, 4714 B.C. (Proleptic Gregorian calendar<http://en.wikipedia.org/wiki/Proleptic_Gregorian_calendar>). -- -- -- --ô¿ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users