RE: Fuzzy results from NOW()-... in select statement?

2001-06-21 Thread Don Read
On 21-Jun-01 Sebastiaan J.A. Kamp wrote: > As I tried to find out how many entries are written to a 'log' table in the > past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been > able to find any reason (NOW()-60) should result in something completely > different from (NOW()-1

Fuzzy results from NOW()-... in select statement?

2001-06-21 Thread Sebastiaan J.A. Kamp
As I tried to find out how many entries are written to a 'log' table in the past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been able to find any reason (NOW()-60) should result in something completely different from (NOW()-120), could somebody clarify what's going on her