MySQL date functions that help you directly get required part of date. Commonly used MySQL date functions. These MySQL date functions are easy to remember.
date format
How to calculate age from date of birth in SQL
Here’s how to calculate age from date of birth in SQL you can use the following MySQL query. This is useful to find out recency of activity.