SQL Puzzle: SQL Advance Query - How to get the Name of Month

SQL Puzzle: SQL Advance Query – How to get the Name of Month

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output and get the name of Month Name.

Expected Output for Month 1:

Month_Name

--------------

January

Check different Solutions:

SELECT DATENAME(month, '2018-01-01') AS Month_Name

SELECT DATENAME(month , DateAdd( month , 1 , 0 ) - 1 ) AS Month_Name

SELECT DATENAME(month, '2018-01-01') AS Month_Name

SELECT DATENAME(month , DateAdd( month , 1 , -1 )) AS Month_Name

SELECT DATENAME(month, STR(YEAR(GETDATE()), 4) + REPLACE(STR(1, 2), ' ', '0') + '01') AS Month_Name

SELECT CONVERT(CHAR(3), DATENAME(MONTH, '2018-01-01')) AS Month_Name

SELECT DATENAME(M, DateAdd(M, 1, -1)) AS Month_Name

Please try the different solution for this puzzle and share it via comment...

Mar 15, 2018Anvesh Patel

Comments: 2

Ankush

September 14, 2018 at 7:51 am

Select to_char(to_date(’01-01-2018′,’dd-mm-yyyy’),’Month’) from dual

koustav

October 30, 2019 at 2:03 pm

Select to_char(to_date(’01-01-2018′,’dd-mm-yyyy’),’Month’)

SQL Puzzle: SQL Advance Query – How to get the Name of Month