SELECT DATENAME(m,CreatedDate)from Empolyees will return the month name.

> Hi 
I have the date entered available in the database in MM/DD/YY format.
 
Table Name : Employees
Column Name: CreatedDate
Value:01/25/2002
 
Now I have to retrieve the month part of the created date as January.
 
I understand that Select Month(CreatedDate) from employees 
would return me a value1.
 
I need my query to return January.
 
How would I do this?
 
Thanks for your time
Vittal