Thursday, December 4, 2008

Month Name from the Date

This example extracts the month name from the date returned by GETDATE.

SELECT DATENAME(month, getdate()) AS 'Month Name'


Here is the result set: Month Name
------------------------------
February

0 comments: