Question

Write sql query for SELECT MONTHNAME ('2021 - 04 - 10')


SELECT MONTHNAME(CURDATE ())

Answer 1

Month Name :- This function returns the name of the month for a date .

Syntax :- MONTHNAME ( date )

SELECT MONTHNAME ('2021 - 04 - 10')

Output = April

°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°

SELECT MONTHNAME(CURDATE ())

Output = August

Answer 2

Answer:

To get a month from a date field in SQL Server, use the MONTH() function. This function takes only one argument – the date. This can be a date or date and time data type.