В сообщении от 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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
