Get current year, current month and current day in MySQL

Last updated on September 11th, 2020 at 10:19 am

Here are a few commonly used commands to find current year, current month and current day in MySQL.

Get current year in MySQL in 4 digits:

select year(now()) as 'current year';

or

select date_format(now(),'%Y') as 'current year';
+----------------+
|  current year  |
+----------------+
|     2013       |
+----------------+

Get current year in MySQL in 2 digits:

select date_format(now(),'%y') as 'current year';
+----------------+
|  current year  |
+----------------+
|       13       |
+----------------+

Get current month in MySQL:

select month(now()) as 'current month';

or

select date_format(now(),'%m') as 'current month';
+----------------+
|  current month |
+----------------+
|       12       |
+----------------+

Get current month name in MySQL:

select date_format((now(),'%M') as 'current month';
+----------------+
|  current month |
+----------------+
|    December    |
+----------------+

Get abbreviated current month name in MySQL:

select date_format((now(),'%b') as 'current month';
+----------------+
|  current month |
+----------------+
|       Dec      |
+----------------+

Get current day of the month in MySQL:

select day(now()) as 'current day';
+----------------+
|  current day   |
+----------------+
|        1       |
+----------------+