0 votes
1 view
in SQL by (36k points)

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

1 Answer

0 votes
by (86.8k points)

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 certification course by Intellipaat that provides instructor-led training, self-paced videos, and certification also.

Related questions

0 votes
1 answer
asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
asked Apr 21 in SQL by Sudhir_1997 (36k points)
0 votes
1 answer
asked Apr 21 in SQL by Sudhir_1997 (36k points)
0 votes
1 answer
asked May 6 in SQL by Sudhir_1997 (36k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...