mysql> SELECT (on_svcdate - interval 1 day)   FROM TABLE where ip='XXX.XX.XX.XX';
+-------------------------------+
| (on_svcdate - interval 1 day) |
+-------------------------------+
| 2011-08-15                    |
+-------------------------------+
1 row in set (0.09 sec)