Alexey Pechnikov wrote: > В сообщении от Monday 09 June 2008 17:52:24 Dennis Cote написал(а): > >>If you >>consider dates to be equal when the two dates are the same to within one >>second, then you could use that value as your maximum difference. Since >>a julian day number has units of days, you can use a value of 1/86400 >>days (i.e. 1 second) as your epsilon value. The same value can be used >>to test for less than as you are doing in your query. The save_date is >>less than the specified value if the difference is greater than this >>epsilon value. >> >> select save_date >> from photo_tags >> where 2454612.21079943 - save_date > 1/86400; > > > Well, but what is precision of sqlite timer?
Sqlite just gets the date and time from the underlying OS. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users