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 here?
'changed' is a TIMESTAMP(14) field...
mysql> SELECT COUNT(*) FROM web WHERE changed >= (NOW()-60);
+----------+
| COUNT(*) |
+----------+
| 363564 |
+----------+
1 row in set (7.00 sec)
mysql> SELECT COUNT(*) FROM web WHERE changed >= (NOW()-120);
+----------+
| COUNT(*) |
+----------+
| 38 |
+----------+
1 row in set (8.27 sec)
mysql> SELECT COUNT(*) FROM web WHERE changed >= NOW()-120;
+----------+
| COUNT(*) |
+----------+
| 37 |
+----------+
1 row in set (6.40 sec)
mysql> SELECT COUNT(*) FROM web WHERE changed >= NOW()-60;
+----------+
| COUNT(*) |
+----------+
| 364119 |
+----------+
1 row in set (7.46 sec)
Hope someone can shed some light for me ;-)
K.R.,
Sebastiaan Kamp