mysql> select now(); select now() -10;
+———————+
| now() |
+———————+
| 2009-09-25 21:07:20 |
+———————+
1 row in set (0.00 sec)
+———————–+
| now() -10 |
+———————–+
| 20090925210710.000000 |
+———————–+
1 row in set (0.00 sec)
sometime it works, but sometime doesnt for
" mysql now() Incorrect datetime value for column "
There's an insidious problem doing simple maths using now() … subtraction of seconds and minutes etc are based on 100 seconds in a minute, and 100 minutes in an hour …
so, you need to be do something more like:
select now(); select now() -INTERVAL 10 SECOND;
and that's how to solver the problem.