Hello! On Thursday 24 September 2009 05:54:12 Dan Bishop wrote: > > Can you add this note to documentation? This is very speculate question. > > Especially because internal SQLite representation of julianday was chanded > > some times ago. > It's not a date-specific issue; the same thing occurs with ordinary numbers. > > sqlite> select (1.0/49)*49 = 1.0; > 0
Yes it is, but for ordinary numbers is not useful to check like this select (1.0/50)*50 = 1.0; 1 The equality check of midnights in julianday format is more common task. I see this question in the mail list every week. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
