How to get the current month in SQL query?

Question

I run this type of query every month and I have to change the month number manually for the current-running month.

SELECT * 
FROM table_1
WHERE year = '[current month]'

Is there any way I can automate this process through a query which can fit in the month number automatically?

Answer 1

you can use this code for find month

SELECT MONTH(getdate()) AS "Present Month";