mysql> select datediff(curdate(),substring('(2006.8.15)asdfasdfasdf',2,9)) as da
y;
+------+
| day |
+------+
| 36 |
+------+
1 row in set (0.00 sec)
y;
+------+
| day |
+------+
| 36 |
+------+
1 row in set (0.00 sec)
我的意思是用()这个标志来判断,谢谢