How to write SQL Query to get the value of the previous month and year?

Question

Aryan Kumar · Answer

Sure, here is how to write a SQL query to get the value of the previous month and year:

SQL

SELECT
  MONTH(CURRENT_DATE() - INTERVAL 1 MONTH) AS previous_month,
  YEAR(CURRENT_DATE() - INTERVAL 1 MONTH) AS previous_year;

This query will first calculate the current date and then subtract 1 month from it. The MONTH() function will return the month number of the date, and the YEAR() function will return the year number of the date.

The results of the query will be the previous month and year. For example, if the current date is January 1, 2023, then the results of the query will be 12 and 2022.

Here is an explanation of the query:

The SELECT statement specifies the columns that you want to return. In this case, you want to return the previous_month and previous_year columns.
The CURRENT_DATE() function returns the current date.
The INTERVAL 1 MONTH expression creates a time interval that is 1 month long.
The - operator subtracts the time interval from the current date.
The MONTH() function returns the month number of the date.
The YEAR() function returns the year number of the date.

forum

How to write SQL Query to get the value of the previous month and year?

Can you answer this question?

1 Answers