More than 5 years have passed since last update.

mysqlで年齢計算

MySQL

Posted at 2014-02-25

年齢計算のsql

mysql> select (YEAR(CURDATE())-YEAR(date_of_birth)) - (RIGHT(CURDATE(),5)<RIGHT(date_of_birth,5)) AS age from users;
+------+
| age |
+------+
| 36 |
+------+
1 row in set (0.00 sec)

参考

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up