How to get month from date in SQL?

Question

Can anyone tell me how to get month from date in SQL?

Answer 1

We can use MONTH() function to get the month from date in SQL. Here is the syntax to get the month from date in SQL:

SELECT MONTH(Date) AS Month;

Here is the syntax to get the month from the current system date:

SELECT MONTH(CURDATE());

If you are interested in SQL, then enroll in this SQL training course by Intellipaat that provides instructor-led training, self-paced videos, and certification also.