Afficher un message
Vieux 07/02/2008, 12h22   #3
Vincent van Scherpenseel
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Retrieving existing record yields no result

Rik Wasmus wrote:
> <snip>
> Floating point precision problem. Decide the precision you need (I'd say
> 0.005):
> SELECT * FROM rt_hour WHERE (server_id = 9 AND date = '2008-02-03
> 17:30:00' AND rt BETWEEN 0.78 - 0.005 AND 0.78 + 0.005);
>
> ... which is why I prefer working with integers.


Ah, that makes sense - Does the DECIMAL datatype also has this
precision problem, or is that more like an integer?

Thank you for your time,
Vincent van Scherpenseel
  Réponse avec citation
 
Page generated in 0,05187 seconds with 9 queries