Posted in SQL Server Getting Month Name in Sql Server Posted on July 27, 2011July 27, 2011 by ABC_MS .Net In Sql Server DatePart function with part as a MM returns the month value. And DateName function with part as a MM returns the month name. Select DATENAME(MM,Date) As MonthName From Tbl_CompanySharesPrice 0.000000 0.000000 Share this:TwitterFacebookLike Loading... Related Author: ABC_MS .Net a to z View All Posts