After experiencing some difficulty with comparing dates stored internally as a floating point I was informed about the following.
"... due to the way floats are stored in computers, '=' isn't really a good choice of an operator for them. Instead of Date = 38953.5890509 you should use Date > 38953.5890508 AND Date < 38953.5890510" Is there any way to set a precision value? 10 or 12 even 8 decimal places would be fine in this instance for SQLite "REAL" data so that what is "seen" can be compared without surprises? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
