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
Get current year, current month and current day in MySQL
Here are a few commonly used commands to find current year, current month and current day in MySQL. You can use date format is different variations for it.
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.
How to find difference between two dates in MySQL
Calculating difference between two dates in MySQL is really easy. Here’s how you can do it. Let’s say dt1 and dt2 are 2 columns in table table_name.