请问大家在mysq中能进行时间运算吗？

Question

可以呀~~
给楼主个例子mysql> SELECT name, (TO_DAYS(NOW())-TO_DAYS(birth))/365 FROM pet;
+----------+-------------------------------------+
| name     | (TO_DAYS(NOW())-TO_DAYS(birth))/365 |
+----------+-------------------------------------+
| Fluffy   |                                6.15 |
| Claws    |                                5.04 |
| Buffy    |                                9.88 |
| Fang     |                                8.59 |
| Bowser   |                                9.58 |
| Chirpy   |                                0.55 |
| Whistler |                                1.30 |
| Slim     |                                2.92 |
| Puffball |                                0.00 |
+----------+-------------------------------------+

Answer 1

这个问题我已解决了，多谢skystar2001(波塞冬)了，不过你的
TO_DAYS(birth))中的birth为列名吧，你这样直接对列进行函数调用或算术计算，会使查询的效率很底的。