Do we have an inbuilt function to get the name of the month from date directly? We know we have a function month(date) where we can get the month number and then we can use a case function to get the name of the month but I am looking out for a direct funtion.
This can be done hands down in SQL Server like below.
SELECT DATENAME(month, '12:10:30.123') Month_name, DATENAME(weekday, '12:10:30.123') day_name
Month_name day_name
January Monday