数据库-日期计算-获取年月日

日期计算

查看宠物多少岁，就可以使用计算日期的函数TIMESTAMPDIFF()

#查询当前的日期
mysql> select curdate() from pet; 
+‐‐‐‐‐‐‐‐‐‐‐‐+ 
| curdate() | 
+‐‐‐‐‐‐‐‐‐‐‐‐+ 
| 2018‐08‐09 | 
+‐‐‐‐‐‐‐‐‐‐‐‐+ 
#获取当年的年
mysql> select YEAR('2018‐02‐05') AS YEARS from pet; 
+‐‐‐‐‐‐‐+ 
| YEARS | 
+‐‐‐‐‐‐‐+ 
| 2018 | 
+‐‐‐‐‐‐‐+ 
#获取当年的月
mysql> select month('2018‐02‐05') AS YEARS from pet; 
+‐‐‐‐‐‐‐+ 
| YEARS | 
+‐‐‐‐‐‐‐+ 
| 2 | 
+‐‐‐‐‐‐‐+ 
#获取当年的日
mysql> select day('2018‐02‐05') AS YEARS from pet; 
+‐‐‐‐‐‐‐+ 
| YEARS | 
+‐‐‐‐‐‐‐+ 
| 5 | 
+‐‐‐‐‐‐‐+ 

mysql> SELECT name, birth, CURDATE(), 
‐> TIMESTAMPDIFF(YEAR,birth,CURDATE()) AS age 
‐> FROM pet;